Microsoft SQL Server listens for incoming connections on a particular port. The default port for SQL Server is 1433. However, it doesn't need to be 1433.
It is a bit tricky to connect to the SQL Server running on a non-standard port. When connecting to the SQL Server running on a non-standard port, many people instinctively try to specify the server address in a IP:PORT format. Unfortunately, this doesn't work.
In order to connect to an SQL Server running on a non-standard port, you must specify the server address in a IP,PORT format. For example, if the IP address of the server is 235.12.175.96 and the SQL Server listens to 1037 port, you must specify 235.12.175.96,1037 as the server name.
Connecting SQL Server Management Studio to a Non-standard TCP/IP Port
Saturday, October 27, 2007Posted by George S. at 3:53 AM
Labels: Databases, SQL Server
Subscribe to: Post Comments (Atom)
2 comments:
Thanks for the info. Pretty annoying they didn't go with the standard IP:PORT setup.
Where does the named instance go?