Database Connection Repair

If the database can't be accessed when trying to run Venafi Configuration Console, the Database Connection Repair wizard will be shown.

If the database server is experiencing temporary downtime, Trust Protection Platform will resume working correctly when connectivity is restored. However, if the database connection information changes, you will need to repair the database connection.

To repair the database connection

  1. On the application sever, open the Venafi Configuration Console.

    If the Configuration Console opens, the application server was able to communicate with the database, and you do not need to continue.

    If the application server was not able to communicate with the database, the Database Connection Repair wizard opens.

  2. Read the information in the Database Connection Repair window, then click Next.

  3. Update the database connection information, then click Finish.

    • If the application server was able to connect using the updated information, the wizard will show that installation is complete, and you can click Close.
    • If the application server was not able to connect using the updated information, the wizard will show a connection error. Correct any errors in the database settings, and click Finish.

To repair the database connection from the command line

  1. On the Venafi server, open a command prompt and browse to the Venafi\Platform directory.

    If you installed Trust Protection Platform in the default directory, you would browse to the following location:

    c:\Program Files\Venafi\Platform

  2. Run the configuration utility (TppConfiguration.exe) with the -dboconfig switch. The format is:

    TppConfiguration.exe "-dboconfig:<cfg>"

    For example:

    TppConfiguration.exe -dboconfig:"Data Source=192.168.1.1,1433;Initial Catalog=databasename;User ID=dbOwnerUser;Password=S0me\"thing-Complex!"

    To obtain your current SQL configuration string, see Obtaining the SQL database connection string.

  3. Restart the Venafi Windows services.
  4. Restart the Venafi IIS Application Pools, or perform an IIS Reset.

IMPORTANT  The quotation mark " and backslash \ characters are special characters, and if included in the password, you need to include a backslash to escape them. So if the password is pas"sw\ord, you would enter it into the connection string as pas\"sw\\ord.

To learn more about the TPPConfiguration utility, see Using the TppConfiguration command line tool.