|
My host uses a different port from the default (1433) for SQL Server 2005 and I am having trouble connecting to it using the Microsoft SQL Server Management Studio.
|
|
|
Microsoft documentation does not adequately describe how to connect to an alternate port on the SQL Server from the client tools. However, it is pretty easy to connect to a port different from the SQL Server default of 1433 by specifying it in the Server Name field. When entering your server name in the connection properties, you first type in your server’s IP address or fully qualified domain name followed by a comma and then the port number. So your Server Name field should look something like the following if you were using port 1555:
...by IP address:
10.20.30.45,1555
...by Fully Qualified Domain Name:
db9.myhost.net,1555
|
