1.Configure SQL Server to allow Remote Connections

Follow the steps outlined below to configure SQL Server to permit remote connections.

  1. Open SQL Management Studio

  2. Right-click on the server and select Properties.

  3. Figure 1: Right-Click Server: Properties

  4. On the Connections tab check the Allow remote connections to this server

  5. Figure 2: Connections: Allow remote connections to this server

  6. Open SQL configuration utility SQL Server Configuration Manager.

  7. Figure 3: Protocols for SQLEXPRESS: TCP/IP

  8. In the SQL Server Network Configuration section, select Protocols for <your instance name>

  9. Ensure TCP/IP is Enabled. To edit this setting, right-click and select Properties.

  10. If necessary, change the “Enabled” setting to “Yes”.

  11. Select the IP Address tab (same dialog in step 4 above)

  12. Figure 4: TCP/IP Properties

  13. Scroll down to section titled IPAll

  14. Update TCP Dynamic Ports. It should be blank.

  15. Update TCP Port. It should be 1433.

  16. Press OK to save changes. You will be prompted to restart the SQL service.

  17. Figure 5: Warning message box

  18. Select SQL Server Services

  19. Figure 6: Restart SQL Server Services

  20. Select SQL Server (<your instance name>)

  21. Select Restart

  22. To enable the SQL Server Browser service, right-click on the Service and select Properties

  23. Figure 7: Enable SQL Server Browser Service

  24. On the Properties screen select Start Mode and update the setting to Automatic

  25. Figure 8: SQL Server Browser Properties

  26. Start the SQL Server Browser

  27. Figure 9: Start SQL Server Browser

2.Configure Windows Firewall to allow inbound traffic to SQL Server

Follow the steps outlined below to configure the Windows firewall to allow inbound traffic to SQL Server.

  1. If you are using the Windows firewall, you will need to open ports 1433 and 1434. Open the Windows Firewall

  2. Figure 10: Open Windows Firewall

  3. Select Advanced Settings

  4. Figure 11: Advanced Settings

  5. Create a new Inbound Rule by selecting Inbound Rules then New Rule

  6. Figure 12: New Inbound Rule Wizard: Port

  7. Select Port and Next

  8. Figure 13: Specify the protocols and ports to which the rule applies

  9. Select TCP and Specific local ports, then enter 1433

  10. Choose Next to continue to the next screen

  11. Select Allow the connection and choose Next

  12. Figure 14: Specify the action

  13. Select all three options and then press Next

  14. Figure 15: Specify the profiles for which the rule applies

  15. Give the rule a name and press Finish

  16. Figure 16: Specify Name & Description of rule

  17. Confirm you see the new inbound rule

  18. Figure 17: New Inbound rule added

  19. If you are using a named instance of SQL Server (Example:\SQLExpress) you will need to repeat these steps for port 1434 UDP

  20. IMPORTANT! Port 1433 is TCP and 1434 is UDP
Suggest Edit