Getting Error: "The EXECUTE permission was denied on the object" during the upgrade to 15.3

Applies To:

Trust Protection Platform 15.3

Microsoft SQL

Symptom:

Getting the following error during the upgrade to TPP 15.3: "The EXECUTE permission was denied on the object"

Cause:

When configure to use Windows Authentication to the database, the user logged into the Windows Server needs to be granted stored procedure and type access unless they are DB owner.

Resolution:

Do the following to resolve the issue:

1. Run the sample grants script against the user logged into Windows. The script can be found with the Trust Protection Platform installation files obtained from the FTP site.
2. Re-run the VCC wizard  (Run as Administrator) by clicking on Start > Venafi Control Center and choosing "Configure Products"

More Information:

Sample Grants Script from TPP 15.3:

-- In the below script, replace DIRECTOR_RW with the username of the account that
-- will be used in the Trust Protection Platform.

GRANT EXECUTE ON TYPE::dbo.ConfigObjectRels TO [DIRECTOR_RW]

GRANT EXECUTE ON OBJECT::dbo.RefreshConfigObjectRels TO [DIRECTOR_RW]
GRANT EXECUTE ON OBJECT::dbo.EnqueueLog TO [DIRECTOR_RW]
GRANT EXECUTE ON OBJECT::dbo.DequeueLog TO [DIRECTOR_RW]
GRANT EXECUTE ON OBJECT::dbo.GetOrCreateConversation TO [DIRECTOR_RW]

-- Must have receive service on FROM queue to initiate dialogs
GRANT RECEIVE ON LogClientQueue TO [DIRECTOR_RW]
-- Must have receive service on FROM queue to retrieve from queue.
GRANT RECEIVE ON LogServerQueue TO [DIRECTOR_RW]