How To: Configure the SQL Server database to work on a fixed TCP/IP Port 1433 instead of dynamic ports

This article describes how to configure the SQL Server database to work on a fixed TCP/IP port (Port 1433) instead of dynamic ports.

Step-by-step guide

1. Open SQL Server Configuration Manager.
   To open the configuration manager, you can use Windows search or use Run command sqlservermanager<version_number>.msc. Identify the version number from the following table . Version number changes for different SQL Server version.
   
   

2. In the left hand pane, expand SQL Server Network Configuration. 
   
   

3. Click on Protocols for <instance name>.
    

4. In the right hand pane, check if TCP/IP is Enabled; if it is Disabled, right click TCP/IP and select Enable. 
    

5. Further ensure the port 1433 is mentioned as fixed port. Double click on TCP/IP to open Properties window.
    

6. In the Protocol tab, Enabled must be Yes, Listen All must be Yes. Change accordingly if any different value found.
    

7. In the IP Addresses tab, go to the bottom of the list and locate the IP ALL section check.
   
   

8. Ensure TCP Port value is 1433. If found empty, mention the port number. If any different port number found there, contact your sysadmin team, they probably set any non-default port for SQL Server.
    

9. Click OK.
    

10. In the left pane go to SQL Server Services menu and restart the SQL Server (Instance name) service. Close the configuration manager.

SQL Server version number

Related articles