Trust Protection Platform from 15.3 to 19.4
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
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.
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.