Change default port when registering a new SQL 2000 server

Question

Hi All,

I'm trying to register an externally hosted SQL 2000 server through Enterprise Manager which isn't on the default port and I can't see anywhere to change it within Enterprise Manager.

So, the question is, how do I connect to the database if:

I.P Address is 123.456.789 (example)

Port is 1334

Thanks in advance

EDIT: Both Rob and Denny Were correct however I still couldn't access the SQL 2000 Server as we had to open port 1334 on our firewall to allow access to the external server.

Answer 1

I found this via Google:

You add a comma and the port number to the end of the server name.

So if you want to connect to MySqlServer.MyDomain.com on port 3821, you type...

MySqlServer.MyDomain.com,3821

Answer 2

Rob is correct - I have a SQL 2000 server running on the non-default port on a different instance name and the way I access it is like this:

[ip or dns name]\[instance], [port]

example:

my.server.com\MSSQLSERVER2, 12345

You don't need \[instance] if you used the default sql server instance when you installed.