Configuring SQL Server to Accept Remote Connections

When configuring Ivanti Endpoint Security for use with a remote SQL Server instance, you must configure that instance to accept remote connections.

Perform this task on the server hosting the SQL Server instance you want to use with Ivanti Endpoint Security (Ivanti Endpoint Security).

  1. Using the Start menu or the Start screen, open SQL Server Configuration Manager.
    SQL Server Configuration Manager opens.
  2. Expand the tree to Protocols for Ivanti Endpoint SecuritySQLInstanceName.
    Example: For example, for the default Ivanti Endpoint Security SQL install, select SQL Server Configuration Mnager (Local) > SQL Server Network Configuration > Protocols for UPC.
  3. Enable the TCP/IP protocol for your instance.
    1. From the main pane, double-click TCP/IP.
    2. Set Enabled to Yes.
  4. Configure the TCP/IP protocol to allow connection from your Ivanti Endpoint Security Server.
    1. From the TCP/IP Properties dialog, select the IP Addresses tab.
    2. From an unused IP node (IP1, IP2, or so on), set Active to Yes.
    3. Set Enabled to Yes.
    4. Set the IP Address to the address of your Ivanti Endpoint Security Server.
    5. Click OK.
    6. Click OK to acknowledge that the service needs to be restarted.
  5. If installing Ivanti Endpoint Security to a named instance of SQL Server, ensure the SQL Server Browser Service is running.
    1. From the tree, select SQL Server Services.
    2. From the main pane, double-click the SQL Server Browser.
    3. Ensure the Service tab is selected.
    4. Ensure that Automatic is selected from the Start Mode list.
    5. Click OK.
    6. From the main pane, right-click SQL Server Browser.
    7. Select Restart (or Start if Restart is unavailable).
  6. From the tree, select SQL Server Configuration Manager (Local) > SQL Server Services.
  7. From the main pane, right-click SQL Server (Ivanti Endpoint SecuritySQLInstanceName) and select Restart.
    Example: Restart SQL Server (UPC).
  8. Close Sql Server Configuration Manager.
    Your SQL Server instance is ready for use with Ivanti Endpoint Security. Proceed with the installation procedure (provided your SQL Server instance is not behind a Windows Firewall).
After Completing This Task:

If your SQL server instance is behind a Windows Firewall, complete Configuring Windows Firewall for SQL Server Instance Access.