TechnowledgeBase

You have a named instance of SQL2005 and need to find its port number. Maybe you’re trying to connect to it with Java and JTDS or maybe you’ve got something else going on. Whatever the reason, you need that number. Here’s how to get it.

1. Launch the Server Configuration manager:
   
   
   
   

2. Expand the Network Configuration node and find your named instance in the list:
   
   
   
   
3. Right click on “TCP/IP” under “protocol name” and select “Properties” from the pop-up menu.
4. On the Properties screen on the “Protocol” tab, find the “Listen All” field. Note what it says there… “Yes” or “No”. Then click on the “IP Addresses” tab.
   
   
   
   

5. The port number is on the “IP Addresses” tab.
   
   
   
   
   If the “Listen All” field on the previous tab said “Yes” then the port number is in the “IPAll” section. If “Listen All” was set to no, then it is in one of the other two sections, depending on what the IP Address of the named instance is. Find the IP Address (use ping if you have to) and use the port number assigned to it.

There’s your port number. Have fun with it.

Popularity: 27% [?]

This entry was posted on Wednesday, July 25th, 2007 at 7:00 am and is filed under Other Microsoft Apps. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.