Completing Remote MSSQL Access Configuration

Prerequisites

• Enable IP Connectivity for MSSQL.
• Start SQL Server Management Studio (SSMS) on the MSSQL host.

Procedure

1. In the SSMS, access the Object Explorer panel.

   

2. Connect to the requires MSSQL server:

   1. In the panel, from the Connect list, select Database Engine.
      Server connection settings appear.

      

   2. In the window that appears, in the Server name field, enter localhost\<server name>.

   3. From the Authentication list, select Windows Authentication.
   4. Click Connect.

3. In the Object Explorer panel, right click localhost\<server name>, and from the action menu select Properties.

   Server Properties

   

   The Server Properties window appears.

4. In the window that appears, in left pane, click Connections.
   Various connection settings appear.

5. In the right pane, in the Connections area, in the Maximum number of concurrent connections... field, enter a number of allowed concurrent servers and/or Dispatcher Apps. Consider two (2) as a minimum

   Example

   Number 2 refers to one server and one Dispatcher App.

   For maximum value, add the following to 2:

   • Number of Additional Dispatchers.
   • Number of Additional Servers
   • Number of Backup (Redundant) Servers

6. In the Remote server connections area, select the Allow remote connections to this server check box.

7. In the same area, in the Remote query timeout field, enter the required server response timeout.
8. In the window, click ОК to apply changes and close the window.
9. Apply changes by restarting MSSQL service:
   1. In the left pane, expand SQL Server Configuration Manager (Local), and then click SQL Server Services.
   2. In the right pane, right click SQL Server, and from the action menu select Restart.

See Also

• MSSQL Prerequisites