SQL Server interview questions & Answers Set 11

Which TCP/IP port does SQL Server run on?

SQL Server runs on port 1433 but we can also change it for better security

 

From where can you change the default port?

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

1. Open the Microsoft SQL Server Enterprise Manager.

2. Right-click on your server instance (you may have to expand the server groups).

3. Choose Properties.

4. Under the General tab, click the button labeled "Network Configuration". The SQL Server Network Utility will be displayed.

5. On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.

6. 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.

7. Hit Apply on the SQL Server Network Utility screen, then OK.

8. 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.

9. Hit OK to close the Properties dialog.

10. Right-click on your server instance again, and choose to stop the SQL Server service.

11. Once it has stopped, right-click and choose to start the SQL Server service. Restarting it will now use the new port.