SQL Server Error VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Error:
VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Cause:
UserAccount does not have View Server State permissions on the SQL Server.
Solution:
- Open the SQL Server Management Studio.
- Connect the Admin or SA account to connect the server.
- Navigate to Security –> Logins.
- Right Click the Service Account —> Select Properties
- Select the Securables page.
- Scroll to the bottom and Grant – View Server State.