\nIn the\u00a0IPn<\/em>\u00a0Properties\u00a0area box, in the\u00a0TCP Port\u00a0box, type the port number you want this IP address to listen on, and then click\u00a0OK.<\/p>\n<\/li>\n\nIn the console pane, click\u00a0SQL Server Services.<\/p>\n<\/li>\n
\nIn the details pane, right-click\u00a0SQL Server (<instance name>)\u00a0and then click\u00a0Restart, to stop and restart SQL Server.<\/p>\n<\/li>\n<\/ol>\n
After you have configured SQL Server to listen on a specific port, there are three ways to connect to a specific port with a client application:<\/p>\n
\n- \n
Run the SQL Server Browser service on the server to connect to the Database Engine instance by name.<\/p>\n<\/li>\n
- \n
Create an alias on the client, specifying the port number.<\/p>\n<\/li>\n
- \n
Program the client to connect using a custom connection string.<\/p>\n<\/li>\n<\/ul>\n
Firewall<\/strong><\/span><\/p>\n\u00a0To open a port in the Windows firewall for TCP access<\/p>\n
\n
\n- \n
On the\u00a0Start<\/strong>\u00a0menu, click\u00a0Run, type\u00a0WF.msc, and then click\u00a0OK.<\/p>\n<\/li>\n- \n
In the\u00a0Windows Firewall with Advanced Security, in the left pane, right-click\u00a0Inbound Rules, and then click\u00a0New Rule\u00a0in the action pane.<\/p>\n<\/li>\n
- \n
In the\u00a0Rule Type\u00a0dialog box, select\u00a0Port, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Protocol and Ports\u00a0dialog box, select\u00a0TCP. Select\u00a0Specific local ports, and then type the port number of the instance of the Database Engine, such as\u00a01433\u00a0for the default instance. Click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Action\u00a0dialog box, select\u00a0Allow the connection, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Profile\u00a0dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Name\u00a0dialog box, type a name and description for this rule, and then click\u00a0Finish.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n
To open access to SQL Server when using dynamic ports<\/h3>\n\n
\n- \n
On the\u00a0Start<\/strong>\u00a0menu, click\u00a0Run, type\u00a0WF.msc, and then click\u00a0OK.<\/p>\n<\/li>\n- \n
In the\u00a0Windows Firewall with Advanced Security, in the left pane, right-click\u00a0Inbound Rules, and then click\u00a0New Rule\u00a0in the action pane.<\/p>\n<\/li>\n
- \n
In the\u00a0Rule Type\u00a0dialog box, select\u00a0Program, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Program\u00a0dialog box, select\u00a0This program path. Click\u00a0Browse, and navigate to the instance of SQL Server that you want to access through the firewall, and then click\u00a0Open. By default,\u00a0SQL Server is at\u00a0C:\\Program Files\\Microsoft SQL Server\\MSSQL11.MSSQLSERVER\\MSSQL\\Binn\\Sqlservr.exe. Click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Action\u00a0dialog box, select\u00a0Allow the connection, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Profile\u00a0dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click\u00a0Next.<\/p>\n<\/li>\n
- \n
In the\u00a0Name\u00a0dialog box, type a name and description for this rule, and then click\u00a0Finish.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
TCP IP Port in SQL Server 2012<\/p>\n
As an SQL Server Administrator you might need to find SQL Server TCP IP port configured for your SQL Server Instance. There are many reason to find it but most famous reasons is to give access to developer and set firewall exception if there is any. Generally 1433 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2026"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2026"}],"version-history":[{"count":7,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2026\/revisions"}],"predecessor-version":[{"id":2038,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2026\/revisions\/2038"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"1SQLServerConfigurationManager\"](\"http:\/\/rmohan.com\/wp-content\/uploads\/2013\/05\/1SQLServerConfigurationManager.png\")
<\/a><\/p>\n![<\/a>](\"http:\/\/rmohan.com\/wp-content\/uploads\/2013\/05\/2SQLServerConfigurationManagerTCPIPProperty.png\"){kind=link}