There will be a list of various adapters ranging from 'IP1' to 'IPAll' for each adapter remove any zeros (0) from the 'TCP Dynamic Ports' dialog box (a zero in that box indicates that the database engine is listening on a dynamic port). In the pop-up, choose the 'IP Addresses' tab. The screenshot shows the navigation, as well as the difference between a default and named instance: This will populate the right hand navigation pane right click 'TCP/IP' and choose 'Properties'. Open it and expand the 'SQL Server Network Configuration' node, then single click 'Protocols for MSSQLSERVER' (if you're changing the port for a named instance, the node will be 'Protocols for '). We'll use the 'SQL Server Configuration Manager' to assign a specific port to our instance. Note: discussion of the above points is beyond the scope of this article SQL Server Configuration Manager (This is a weak form of security and should not be used as a sole means of protection)Ģ) For named instances the port can be specifically defined to allow for disabling of the SQL Server browser service.ģ) For named instances, a specifically defined port enables firewalls to be placed around the SQL Server server. Some reasons to change the listening port:ġ) As the default port 1433 could be targeted by attacks it could be changed to limit exposure. A named instance, by default, uses a dynamic port that it chooses from a list of available ports.
#Navicat data modeler change port sql server how to#
Here I will outline how to change that port number.īy default, SQL Server will use port 1433 for incoming communication.
In a previous article, I showed how to find which port SQL Server is using to accept connections to the SQL Server engine ( ).
0 kommentar(er)
