Step 3: Verify the Log Database connection

Use the Windows ODBC Data Source Administrator on the Policy Server machine to verify the ODBC connection to the Log Database.

Steps

  1. Open the Data Sources tool:
    • Windows Server 2016: Go to Start, then select All Programs > Windows Administrative Tools > ODBC Data Sources (64-bit).
    • Windows Server 2012: Go to Server Manager > Tools > ODBC Data Sources 64-bit.
    • Windows Server 2008: Go to Start > Administrative Tools > Data Sources (ODBC).
  2. On the System DSN tab, select the appropriate data source name (by default, wslogdb70), and then click Configure.
  3. Verify that the correct database server machine is selected, and then click Next.
  4. Enter the credentials used to connect to the database, and then click Next.
  5. Accept the defaults on the next 2 screens, and then click Test Data Source.
    Note:

    If the test fails, check the database server machine name and try again.

    If the machine name is correct, but the test continues to fail, verify that the correct connection port is being used, and that the firewall allows communication on the selected port.