Thursday, July 21, 2011

Find Port Number Of The SQL Server 2008

When applications use TCP/IP for network communication, you need to know the port number where the server is listening for connect request from the client.

If you want to connect to the SQL Server through the TCP/IP, you must know on which port number the SQL Server is listening for connection requests. 

Follow this steps to find and verify the port number of your SQL Server.

Step 1. Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.

Step 2. Click on “SQL Server 2005 Network Configuration” to see the list of SQL Server instances.

Step 3. Click on “Protocols for SQL2008”. You will see a list of protocols.

Step 4. Right-mouse click on TCP/IP and select the “Properties” command. The properties dialog box shows up.
Click the IP Address tab. The server IP address and port number used by the SQL Server will be displayed. 

You should see something like below:
IP Address: 127.4.7.1
Ports: 1433
TCP/IP port numbers required to communicate to SQL over a firewall, Finding the Port Number for a particular SQL Server Instance, How do I connect to SQL Server on a port other than 1433, SQL Server Port Numbers, How do I change a SQL port number, Checking Port Numbers, How can I find sql server port number from windows registry, What TCP Port is SQL Server running under, sql server default port number, sql server port number connection string, sql server port number named instance, how to find sql server port number in sql server 2008, sql server port number how to find check sql server port number sql 2008, sql server port number 2008, sql server port number query, how to find sql server port number in sql server 2012, how to find sql server port number in sql server 2005, R2,

0 comments:

Post a Comment