Log Server installation: Error connecting to SQL Server

Before you begin

When the installer displays a SQL Server connection error, you can either:
  • Exit the installer, correct the problem and re-run the installer.
  • Leave the installer open, correct the problem and return.

To address the problem:

Steps

  1. Make sure the Microsoft SQL Server machine is running and available on the network.
  2. Use the Windows Services tool (Start > Administrative Tools > Services or Server Manager > Tools > Services) to make sure the following services are running:
    • SQL Server

      If you are using the default instance, the full service name is SQL Server (MSSQLSERVER).

    • SQL Server Browser
    • (SQL Server Standard or Enterprise) SQL Server Agent

      If you are using the default instance, the full service name is SQL Server Agent (MSSQLSERVER).

      SQL Server Express does not require the SQL Server Agent service.

  3. Double-check the SQL Server host name or IP address, instance name, and port:
    • If you entered the hostname, try using the IP address.
    • The instance name (if any) is entered as part of the hostname or IP address. For example, 10.201.55.13\instance_name.
    • The default port is 1433.
  4. Verify the authentication method used to connect to the database:
    • To specify a Windows trusted connection, the logon account used when running the installer must be a trusted account with appropriate permissions.
    • To specify a SQL Server account, verify that the account name and password are correct and the account has the appropriate permissions.
    See Log Database permissions.
  5. Make sure you are running a supported version of Microsoft SQL Server.
    The supported SQL Server versions are listed in the Certified Product Matrix.