Locating The Server Port In SQL Server 2005

Hello and welcome back to my blog… today I was needing to change the port number on one of my production SQL Server 2005 boxes. Wouldn’t you know it… I had to look for it because it has been awhile since I have had to change the port number on the server. So I thought today I would share where you will find the server port number in SQL Server 2005.

From the Start button click on All Programs, then click on Microsoft SQL Server 2005. From there navigate to Configuration Tools and click on SQL Server Configuration Manager. Once the Configuration Manager opens up, expand the SQL Server 2005 Network Configuration. Underneath this you will see Protocols for <your server name> … click on that. This will display the information for this server on the right hand side of the Configuration Manager. On the right side, double-click on TCP/IP. After double-clicking this the TCP/IP Properties dialog box opens up. Click on the tab that reads “IP Addresses” and this will display all of the IP addresses that are assigned to this server. If you have multiple IP addresses assigned (depends upon how many nic cards you have in the server) to this server then scroll to the bottom to where it reads “IPAll“. Underneath this you will see where it reads “TCP Dynamic Ports“… this is where the Server Port number is located and this where you make the change.

I hope this helps and you can use this a reference each time you need to find the server port.