Remote SQL connections

Owned by Timothy Hitchcock
Last updated: May 24, 2020
1 min read

Enable TCP/IP

  • Open the SQL Server Configuration Manager.

  • SQL Manager not found > [add instructions here]

  • In SQL Server Network Configuration select Protocols for [yourServerInstance].

  • In the right-hand pane, make sure that TCP/IP is Enabled.

  • In the SQL Server Configuration Manager, right-click TCP/IP and select Properties.

  • Select the IP Addresses tab and make sure the TCP Port for IPALL is 13000. (PORT NUMBER IS ARBITRARY e.g "13000")

  • Restart the SQL Server Service

Open the designated port in your firewall

  • Open Windows Control Panel

  • Click on System and Security > Windows Firewall > Advanced settings.

  • Select Inbound Rules in the left-hand pane, then click New Rule in the right-hand pane.

  • In the New Inbound Rule Wizard select Port.

  • Select TCP and set Specific local ports to 13000.

  • Select Allow the connection.

  • Tick the domain checkbox and the private checkbox.

  • Enter a name for this rule, e.g. Crows Nest Server.

  • Select Finish.

Troubleshooting

Inside of SQL Server Management Studio (SSMS):

  • Verify that server is running

  • Enable remote connections

  • Enable public networks