Tuesday, March 9, 2010

Remote connection to MSSQL server on a specific port

If you use specific port (not 1433 by default) for MSSQL server remote connections, then when you want to connect trough SQL Server Management you must specify the new port in server name with comma, e.g.:
Server name: www.yourserver.com,3281

No comments: