Follow

Info: Understanding Windows Authentication with MS SQL

Applies to:

Venafi Trust Protection Platform

Info:

Windows Authentication with Microsoft SQL Database causes confusion from time to time. This article describes how using Windows Authentication affects behavior of Venafi Trust Protection Platform.

More Info:

If we are using Microsoft SQL with Windows Authentication, it is important to understand the following:

Venafi Control Center uses the logged in user Credentials for the database connection!

  1. Venafi Services will run as the account defined for database connection during Configuration Wizard (VCC).
  2. Venafi IIS Application pools will run as the account defined for database connection during Configuration Wizard (VCC).
  3. VCC will use the use the logged in users Windows account to Authenticate to the DB.

This means that when VCC is run as any other user then the SQL Windows Authentication account there will be problems with Services and Application Pools running. 

 

Windows Administration Console and Venafi Updater also uses the logged in user Credentials for the database connection when using Windows Authentication for the Database Configuration!

Was this article helpful?
2 out of 2 found this helpful

Comments