Wednesday, February 17, 2016

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

With one of the application I have seen below error when working with SQL Server

VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ ( Microsoft SQL Server , Error: 300)

The issue is user don’t have VIEW SERVER STATE permission. Note that this will allow an auditing process to view all data or all database states on the instance of SQL Server.

The below command should solve the issue, but before you grant make sure you understand the implications of granting the below permission.

USE MASTER
GO
GRANT VIEW SERVER STATE TO <username>


Regards,
Satishbabu Gunukula



12 comments:

  1. thanks for the post, it helped me.

    --Raj

    ReplyDelete
  2. Hi I am getting this error when I right click a table/view.But the user has db_owner access for the database he is querying in.The error is

    An exception occured while executing a Transact-SQL statement or batch.

    Additional Information:
    VIEW SERVER STATE permission was denied on object 'server',database 'master'(Error:300)

    ReplyDelete
  3. This blog provides useful information about new techniques and concepts.very impressive lines are given which is very attractive.
    java training in chennai thiruvanmiyur

    ReplyDelete
  4. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to mind.


    Salesforce Training in Chennai Mylapore

    ReplyDelete
  5. thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
    Digital Marketing Course in Chennai

    ReplyDelete
  6. SQL Concept are explained nicely in this blog thanks for it..Java Training in Chennai

    ReplyDelete
  7. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Regards,

    Core JAVA Training in Chennai | JAVA Training in Chennai

    ReplyDelete
  8. Learning new technolgy would help oneself at hard part of their career. And staying updated is the only way to survive in current position. Your content tells the same. Thanks for sharing this information in here. Keep blogging like this.

    iOS App Development Company

    ReplyDelete
  9. Good and nice blog post, thanks for sharing your information.. it is very useful to me.. keep rocks and updating..


    Java Training in chennai

    ReplyDelete