Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the Server Name field in Connection to Server dialog box. To address this, you can specify the Server Name as "<<ServerName>>,<<PortNumber>>" instead of just "<<ServerNumber>>".
Published under: · · · ·