how to access a sql-server on non standard tcp/ip port

jostorero

Hi,

My sql-server listen on tcp/port 20000.
I've defined an alias but couldn't see it in the server list.
I also try to register with the name [ip:20000] but without more success.

Any idea how to do ?

Eddie D

Thank you for your post into the forum.

By default SQL Response will use the default SQL port 1433. To connect to a SQL Server that does not use the default port, follow the steps below:

1. Click the '+ Add SQL Servers'
2. In the dialog box that appears, click the 'Add a SQL Server Not Listed...' button.
3. In the 'SQL Server name' text box type in the server name followed by a comma and port number.

For example to select a server that is using port 20000:
Server1.company.com\SQL2005,20000

4. Click Add button.
5. You should now see the SQL Server you added in steps 2 -4 in the list. Click Add to close the '+ Add SQL Servers dialog.
6. Your SQL Server will now appear in the Server to show list.

Many Thanks
Eddie