If the test fails

Perform the following steps:

Steps

  1. Make sure the Microsoft SQL Server machine is running and connected to the network.
  2. Make sure the connection port entry is correct, and that there is no firewall blocking the port.
    The default port is 1433, but other ports can be used.
  3. Use the Windows Services tool to verify that 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

      For the default instance, the full service name is SQL Server Agent (MSSQLSERVER).

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

  4. Make sure that your authentication settings are correct.
    • If you are using SQL Authentication, make sure that the password in the Log Database Connection section of the Settings > Reporting > Log Server page is correct.

      If the password has been changed within SQL Server, it also needs to be changed here.

    • If you are using Windows Authentication, make sure that Log Server is set up to run as a trusted account:
      1. Open the Windows Services tool on the Log Server machine.
      2. Scroll down to find the Websense Log Server service.
      3. Right-click the service name, then select Properties.
      4. Select the Log On tab to view and change account information.
  5. To recreate the database connection, re-enter the database information on the Settings > Reporting > Log Server page.
    • If you are using a SQL instance, make sure the instance name is included as part of the SQL Server location (for example, IP_address\instance_name).
    • Double-check the port entry.
  6. Make sure that the network connection between the Log Server and Log Database machines has not been interrupted.
  7. Make sure Log Server can connect to the DSN server.
    An error indicating that Log Server cannot connect to the DSN server may occur:
    • If Windows User Account Control (UAC) is enabled. Disable UAC.
    • If a hostname, rather than IP address, is specified for the SQL Server location. Use the IP address so that access to the DSN server is not required.