What is the method for setting up remote connections in SQL Server?

2 years ago
Benjamin Taylor
2 minutes

To set up remote connections for SQL Server, you can follow these steps:

  1. To enable the TCP/IP protocol in SQL Server Configuration Manager, follow these steps:
    a. Open SQL Server Configuration Manager.
    b. Choose “SQL Server Network Configuration” in the left panel.
    c. Select the SQL Server instance you want to configure (e.g. “SQL Server 2017”).
    d. Double-click the “TCP/IP” protocol in the right panel.
    e. In the pop-up window, set the “Enabled” property to “Yes”.
    f. Click on the “IP Addresses” tab and make sure the TCP port is set to 1433 (or any other desired port).
    g. Confirm the settings, and close the SQL Server Configuration Manager.
  2. To allow SQL Server port through the firewall:
    a. Open Windows Firewall settings.
    b. Select “Advanced settings”.
    c. Choose “Inbound Rules” in the left panel.
    d. Select “New Rule” in the right panel.
    e. Select the “Port” option, click “Next”.
    f. Choose “TCP” protocol, specify the port number (default is 1433), click “Next”.
    g. Select “Allow the connection” option, click “Next”.
    h. Choose the network type to apply the rule to, click “Next”.
    i. Enter the rule name and description, click “Finish”.
  3. Allow remote connections to SQL Server:
    a. Open SQL Server Management Studio and login to the SQL Server instance with admin credentials.
    b. Right-click on the server instance in the “Object Explorer” window and choose “Properties”.
    c. Select “Connections” from the left panel.
    d. In the right panel, set the “Remote server connections” property to “Allow remote connections to this server”.
    e. Click “OK” to save the changes.

After following the above steps, you will be able to connect to a remote SQL Server instance using SQL Server Management Studio or an application on another computer.

bannerAds