downsouth

Saturday, July 22, 2006

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE SERVER

Open the Microsoft SQL Server Enterprise Manager.
Right-click on your server instance (you may have to expand the server groups).
Choose Properties.
Under the General tab, click the button labeled "Network Configuration". The SQL Server Network Utility will be displayed.
On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that SQL Server listens on. Make the change and hit OK to close the dialog.
Hit Apply on the SQL Server Network Utility screen, then OK.
The system will tell you that the changes are saved, but that they will not take effect until you stop and restart the SQL Server service. Hit OK.
Hit OK to close the Properties dialog.
Right-click on your server instance again, and choose to stop the SQL Server service.
Once it has stopped, right-click and choose to start the SQL Server service. Restarting it will now use the new port.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE CLIENT

Close the Client and any Administrative tools (Customization Manager, User Manager, etc.).
On each Client machine, go to the Client program group and open the Client Network Utility under the Networking folder.
On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that Client connects to on the Server_Name/SQL Server.
Change the entry and hit OK to close.
Hit OK to close and save the changes.