Follow

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

Applies To:

Trust Protection Platform 15.3 and above

Symptom:

During the upgrade process the following errors are seen:

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

Jeremy_-_EnqueueLog.png

 

Object reference not set to an instance of an object

Jeremy_-_Object_reference_not_set_to_an_instance_of_an_object.png

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.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk