What are the challenges you face when working across database platforms? Take the survey

Use a non-standard TCP/IP port for SQL-Server

mike Caboletmike Cabolet Posts: 2
edited July 13, 2005 8:08AM in SQL Compare Previous Versions
I have to connect trough the Internet but our database does not use the default tcp/ip port (1433). I expect it should work the same t as with a browser when we connect to a non standard web site, but I get a connection error
What is the correct way of connection to a different SQL-Server port:
This is not working:


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Mike,

    Good question! SQL Compare uses standard Microsoft connection strings, so the (rather non-intuitive) way to specify the port number is to follow the server name in SQL Compare's server box with a comma, then the port number.

    You can also do some other interesting things with the server box, such as specify a protocol to connect with:

    We'll be improving the connection dialogue in the future so that you can more easily figure out how to put the port number in. We have already added this information into the next version of our help file as well.
This discussion has been closed.