VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.

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:

  1. Open the SQL Server Management Studio.
  2. Connect the Admin or SA account to connect the server.
  3. Navigate to Security –> Logins.
  4. Right Click the Service Account —> Select Properties
  5. Select the Securables page.
  6. Scroll to the bottom and Grant – View Server State.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.