Surf 11 » Connect to SQL Server on Non Standard Port

Finding the best waves on the web.

Need to connect to a SQL Server over TCP/IP on a non standard port (not 1433) with Microsoft SQL Server Management Studio 2005 Enterprise Manager?

Turns out the solution is also non-standard, use a comma in the host name (I had tried a colin, but that doesn't work...)

sqlserver.example.com,61433

Where 61443 would be the non standard port number.



Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact