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

jostorerojostorero Posts: 11
edited November 4, 2008 11:45AM in SQL Monitor Previous Versions
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 ?
jostorero

Comments

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.