how to access a sql-server on non standard tcp/ip port
jostorero
Posts: 11
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 ?
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 ?
jostorero
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com