Error: "The EXECUTE permission was denied on the object 'EnqueueLog'"

Applies To:

Trust Protection Platform from 15.3 to 19.4

Symptom:

During the upgrade process the following errors are seen:

The EXECUTE permission was denied on the object 'EnqueueLog', database 'Director',schema'dbo'

Object reference not set to an instance of an object

Cause:

The reason for these errors are because the Database Service Account that Venafi Platform uses requires Execute and Receive Permissions. The sample-grants.sql script was not run prior to the Venafi Controller running.

Resolution:

To resolve the errors above, please do the following:

• Have a DBA run the sample-grants.sql script found in the  "Database Scripts\MSSQL\Grants" folder that came with your Trust Protection Platform software. Replace DIRECTOR_RW in the script with the username of the account that will be used in the Trust Protection Platform to connect to the database.
  
  Note: If you are using windows authentication to connect to your database, you will also need to run the sample-grants.sql script against the user you are logged into the windows server with.