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.


Satishbabu Gunukula


  1. thanks for the post, it helped me.


  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)

  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

  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

  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

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

  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.

    Core JAVA Training in Chennai | JAVA Training in Chennai

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

    Java Training in chennai

  9. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    oracle training in Bangalore

  10. This comment has been removed by the author.

  11. It is really very helpful for us and I have gathered some important information from this blog..Summer Course in BesantNagar | Summer Course in Chennai

  12. Thanks for posting this useful blog with impressive content.keep updating..
    Best Summer Courses in Saidapet | No.1 Summer Courses in Saidapet

  13. My rather long internet look up has at the end of the day been compensated with pleasant insight to talk about with my family and friends. JAVA Training in chennai

  14. I have been checking out a few of your stories and i can state pretty good stuff. I will definitely bookmark your blog read this post here

  15. writing is very creative work , blog writing is creative work in modern time . your points of views about blog is very unique . keep writing like this this link for the students that is very helpful for the writing services.
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training

  16. Sharing the same interest, Infycle feels so happy to share our detailed information about all these courses with you all! Big data training in chennai & get to know everything you want to about software trainings.

  17. Casinos near DC on I-395 - JTGHub
    A map showing casinos and other 전주 출장샵 gaming facilities located near DC 의왕 출장안마 on I-395, I-395 (also 경산 출장샵 known 광주광역 출장샵 as 서산 출장샵 “Gates of Richmond”), in the area near Richmond,