May 16, 2005 at 9:52 am
I have MS SQL server 2000 installed. It is currently operating on the default port 1433. I need to change the server port to lets say 1500.
Please advise how I should do it and what other configuration settings ( like windows registry ) needs to by updated for this major change.
Many thanks in advance for the help.
Ashok Soni
May 16, 2005 at 10:04 am
Use the Server Network Utility.
May 17, 2005 at 2:31 am
as an additional note to what steve said, u'll have to setup and "Alias" for the server on the client machines after changing the port. This can be done with either the Client Network Utility, or if that is not available, setup an ODBC connection to the server using the new port ... and this sorts out the alias for you!
May 17, 2005 at 5:27 am
It is not a must to use an alias. If port 1434 is open on the server then it will still work to connect to the server like SERVERNAME\INSTANCE. Otherwise you can connect using IP and port number, like 192.168.0.1,1500
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply