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: 69.241.177.66:6660

Comments

  • 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.
    myserver.example.com,1454

    You can also do some other interesting things with the server box, such as specify a protocol to connect with:
    TCP:myserver.example.com,1454

    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.