1.Configure SQL Server to allow Remote Connections
Follow the steps outlined below to configure SQL Server to permit remote connections.
-
Open SQL Management Studio
-
Right-click on the server and select Properties.
-
On the Connections tab check the Allow remote connections to this server
-
Open SQL configuration utility SQL Server Configuration Manager.
-
In the SQL Server Network Configuration section, select Protocols for <your instance name>
-
Ensure TCP/IP is Enabled. To edit this setting, right-click and select Properties.
-
If necessary, change the “Enabled” setting to “Yes”.
-
Select the IP Address tab (same dialog in step 4 above)
-
Scroll down to section titled IPAll
-
Update TCP Dynamic Ports. It should be blank.
-
Update TCP Port. It should be 1433.
-
Press OK to save changes. You will be prompted to restart the SQL service.
-
Select SQL Server Services
-
Select SQL Server (<your instance name>)
-
Select Restart
-
To enable the SQL Server Browser service, right-click on the Service and select Properties
-
On the Properties screen select Start Mode and update the setting to Automatic
-
Start the SQL Server Browser
Figure 1: Right-Click Server: Properties
Figure 2: Connections: Allow remote connections to this server
Figure 3: Protocols for SQLEXPRESS: TCP/IP
Figure 6: Restart SQL Server Services
Figure 7: Enable SQL Server Browser Service
Figure 8: SQL Server Browser Properties
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.
-
If you are using the Windows firewall, you will need to open ports 1433 and 1434. Open the Windows Firewall
-
Select Advanced Settings
-
Create a new Inbound Rule by selecting Inbound Rules then New Rule
-
Select Port and Next
-
Select TCP and Specific local ports, then enter 1433
-
Choose Next to continue to the next screen
-
Select Allow the connection and choose Next
-
Select all three options and then press Next
-
Give the rule a name and press Finish
-
Confirm you see the new inbound rule
-
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
Figure 10: Open Windows Firewall
Figure 12: New Inbound Rule Wizard: Port
Figure 13: Specify the protocols and ports to which the rule applies
Figure 15: Specify the profiles for which the rule applies
Figure 16: Specify Name & Description of rule
Figure 17: New Inbound rule added