Skip to main content
Deutsch 简体中文

How to setup SQL for remote connection?

  • Updated

Question

My SQL server and client (Compass/myQA) are separately installed. After the installation of myQA/Compass, the connection doesn't work. How to setup SQL for remote connection?

Answer

Important: Please consult your IT department before making any changes!

Please follow below steps to configure SQL remote connection:

Step 1

Enable remote connections to your SQL Server.

  • Open SQL Server Management Studio.
  • Right-click your server's name and select Properties.
  • Navigate to Connections.
  • Tick the checkbox Allow remote connections to this server.
  • Select OK.

Step 2

Enable TCP/IP

  • Open SQL Server Configuration Manager
  • In SQL Server Network Configuration, enable TCP/IP mceclip0.png
  • Right-click TCP/IP and then select Properties. In the TCP/IP Properties dialog,press the IP Addresses tab. Set the TCP Port of all IP’s in the list to 1433 (Note: This number may or may not work in your network, please check with your IT department.).
  • Restart the server under SQL Server Services.
  • Select the SQL Server Browser, right click on properties and set the start mode to 'automatic'.

  • To start SQL Server Browser Service

    1. On the computer running SQL Server, run the SQL Server Configuration Manager.

      On the Start menu, in the Search Programs and Files box, type SQL, and then choose SQL Server Configuration Manager.

    2. In SQL Server Configuration Manager, in the navigation pane on the left, choose SQL Server Services.

    3. Right-click SQL Server Browser, and then choose Properties.

    4. mceclip0.png

    5. On the Service tab of the SQL Server Browser dialog box, set the Start mode to Automatic.mceclip1.png 

       

      Choose OK to return to the SQL Server Configuration Manager main page. Right-click SQL Server Browser again, and then choose Start

Step 3

Firewall Configuration

  • Open Windows Firewall with Advanced Security
  • In Inbound Rules - click - New Rule
  • TCP rule
      • In Rule Type page select Port
      • In Protocol and Ports page, select TCP - Specific local ports - input the TCP port (by default is 1433)
      • In Action page select Allow the connection 
      • In Profile page, usually select all three options
      • In the Name page, give this new rule a name.

The UDP rule and SQL Service Rule might be optional. Please consult your IT department before making any additional changes.

  • UDP rule
      • In Rule Type page select Port
      • In Protocol and Ports page, select UDP - Specific local ports - input the UDP port (by default is 1434)
      • In Action page select Allow the connection 
      • In Profile page, usually select all three options
      • In the Name page, give this new rule a name.
  • SQL service rule
      • In Rule Type page select Custom
      • In Program page, click Customize
      • Select Apply to this service
      • In the list select your SQL instance
      • In the Name page, give this new rule a name.
      • Repeat the same for SQL Browser