"Error 300, Procedure : usp_SQL Lock_Read, Message: VIEW SERVER STATE permission was denied on object 'server', database 'master'" (4220276)

Chat now with support

Return

Did this article solve an issue for you?

[Select Rating]

Title

"Error 300, Procedure : usp_SQL Lock_Read, Message: VIEW SERVER STATE permission was denied on object 'server', database 'master'"
Description

When trying to run a Purge or Archive job, the following error may be shown:

"Error 300, Procedure : usp_SQL Lock_Read, Message: VIEW SERVER STATE permission was denied on object 'server', database 'master'"
Resolution

Run the following SQL query on the SQL server where the Change Auditor database is hosted:

USE Master;

GO

GRANT VIEW SERVER STATE TO <YourChangeAuditorCoordinator_SQLAccount>;

GO

Did this article solve an issue for you?

[Select Rating]

Title