Obtaining the SQL database connection string

The connection to the Trust Protection Platform database is stored as a connection string, and can be found in the Venafi Configuration Console. You may need this connection string if you want to do an advanced installation of Trust Protection Platform, or if you need to script an automatic credential change via the command line.

To obtain the SQL database connection string

1. On the Venafi server where Trust Protection Platform is installed, open Venafi Configuration Console.
2. Open the Database node.
3. In the Actions panel, click Properties.
4. If necessary, provide your Trust Protection Platform administrative credentials.

5. Click the Expert tab.

   The connection string shows you everything in the connection string except for the password.

   TIP  The password is not shown for security purposes.

6. Add the password to the string using the following format:

   "-sqlconfig:<SQL string from Venafi Configuration Console>;Password=<Password>"

   For example, if you have the SQL string:

   Data Source=192.168.1.1,1433;Initial Catalog=databasename;User ID=dbuser

   and the password

   S0m3thing-Compl3x!

   Then the entire connection string would be:

   TppConfiguration.exe -sqlconfig:"Data Source=192.168.1.1,1433;Initial Catalog=databasename;User ID=dbuser;Password=S0m3thing-Compl3x!"

   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.