Databased Connection Issued during Setup/Update

When accessing the Verify Privilege Manager console or during an instance update, if one of the databases is unreachable the user is directed to the Connect to Database page.

db connect issue

Reasons for this state:

  • The SQL Server service is not reachable. Check the service and restart if necessary.
  • The SQL Certificate has expired. Delete the old certificate and have the server recreate the certificate.

  • SQL Server authentication method changed. Depending on the selection during initial setup, the credentials used come from either:

    • SQL Integrated Security settings and no further details need to be entered when the first radio button is selected. This is usually the account information for the account running the application pools for Verify Privilege Manager in IIS.
    • Overwrite Account credentials when the second radio button is selected.

If a database connection ever needs to be updated, the Connect to Database page can be accessed locally on the server hosting the Verify Privilege Manager instance by navigating to .../TMS/Setup/Database/ConnectDatabase in the browser. To access the page, the user needs to have local admin rights on the server.