Configure SQL Server For Remote Access Over Internet

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. On the Connections tab check the Allow remote connections to this server
  4. Open SQL configuration utility SQL Server Configuration Manager.
  5. In the SQL Server Network Configuration section, select Protocols for <your instance name>
  6. Ensure TCP/IP is Enabled. To edit this setting, right-click and select Properties.
  7. If necessary, change the “Enabled” setting to “Yes”.
  8. Select the IP Address tab (same dialog in step 4 above)
  9. Scroll down to section titled IPAll
  10. Update TCP Dynamic Ports. It should be blank.
  11. Update TCP Port. It should be 1433.
  12. Press OK to save changes. You will be prompted to restart the SQL service.
  13. Select SQL Server Services
  14. Select SQL Server (<your instance name>)
  15. Select Restart
  16. To enable the SQL Server Browser service, right-click on the Service and select Properties
  17. On the Properties screen select Start Mode and update the setting to Automatic
  18. Start the 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. Select Advanced Settings
  3. Create a new Inbound Rule by selecting Inbound Rules then New Rule
  4. Select Port and Next
  5. Select TCP and Specific local ports, then enter 1433
  6. Choose Next to continue to the next screen
  7. Select Allow the connection and choose Next
  8. Select all three options and then press Next
  9. Give the rule a name and press Finish
  10. Confirm you see the new inbound rule
  11. If you are using a named instance of SQL Server (Example: 192.168.5.30\SQLExpress) you will need to repeat these steps for port 1434 UDP