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.

Unknown's avatar

Author: SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

Discover more from SmartTechWays - Innovative Solutions for Smart Businesses

Subscribe now to keep reading and get access to the full archive.

Continue reading