|  Login
July 23, 2008  
Blog
Minimize
You must be logged in and have permission to create or edit a blog.
  
 
Search
 
Change SQL Server 2000 Port
Minimize
Location: BlogsLiving in Software Development    
Posted by: host 12/21/2007 12:34 AM

I've had to change the port that SQL Server uses to communicate over the Internet several times now, and I'm getting tired of looking it up. Here is is for future reference:

  1. Open SQL Server Enterprise Manager.
  2. Right-click on the server instance.
  3. ClickProperties.
  4. Click the General tab, then click the button marked "Network Configuration" to display the SQL Server Network Utility.
  5. Find TCP/IP under Enabled Protocols on the right. Highlight it and hit the Properties button.
  6. The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server. Change this entry to make SQL Server listen on a different port. Click OK to close the dialog.
  7. Click Apply on the SQL Server Network Utility screen, then OK.
  8. The changes are saved, but they will not take effect until you stop and restart the SQL Server service. ClickOK.
  9. ClickOK to close the Properties dialog.
  10. Right-click on your server instance again, and stop the SQL Server service.
  11. Once it has stopped (sometimes it takes a little while), right-click and choose to start the SQL Server service. Restarting it will now use the new port.

After the port is changed and the service is restarted, the correct syntax to connect is ServerNameOrAddress\InstanceName,portnumber

Permalink |  Trackback

Your name:
Title:
Comment:
Add Comment   Cancel 
Blog
Minimize