How To Find Sql Server Port

Procedure

Named instances (eastward.g. <severname>\Powerlogic or <servername>\SMS3000) of the Database Engine and SQL Server are automatically configured for dynamic ports. This means that they select an available port when the SQL Server service is started, which may vary each time the service is started.

To determine the TCP/IP port number of the instance of SQL Server 2005

1. Open the SQL Server Configuration Director (Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager)
two. Expand SQL Server 2005 Network Configuration and highlight Protocols for <instance proper noun> (due east.g. Protocols for POWERLOGIC)

3. Double-click on TCP/IP in the right window
four. Click on the IP Addresses tab
5. If TCP Dynamic Ports are enabled, the current TCP port being used is listed at the bottom of the window: TCP Dynamic Ports

Note: TCP Dynamic Ports is gear up to 0 to enable dynamic ports

To determine the TCP/IP port number of the case of SQL Server 2000

one. Start the Server Network Utility (Start > All Programs > Microsoft SQL Server > Server Network Utility)
ii. Select the General tab and then select the example proper name of interest (due east.g. SMS3000) from the list of instances

3. Click on the TCP/IP and then select Properties.The TCP/IP port that is being using is listed

For certain situations it may be beneficial for the custom application to employ a static port to connect to SQL

To configure a static port number for SQL Server 2005

1. Open SQL Server Configuration Manager and expand SQL Server 2005 Network Configuration
2. Expand Protocols for <instance proper noun> and double-click TCP/IP
3. Select the IP Addresses tab and under IPALL, gear up the desired TCP Port
iii. A value of 0 in the TCP Dynamic Ports dialog box indicates the apply of dynamic ports. Delete the 0's

four. Click OK.
5. In the panel pane, click SQL Server 2005 Services
6. In the details pane, correct-click SQL Server (<instance name>) and and then click restart, to stop and restart SQL Server

To configure a static port number for SQL Server 2000:

i. Outset the Server Network Utility. (Beginning > All Programs > Microsoft SQL Server > Server Network Utility)
2. In the Server Network Utility dialog box, click the General tab
3. In the Instance(south) on this server listing, select the instance of SQL Server (east.g. SMS3000)
-If TCP/IP protocol is disabled, enable it now. To do this, click TCP/IP in the Disabled Protocols list, and then click Enable
4. In the Enabled Protocols listing, click TCP/IP, and and then click Properties