3

The strangest thing is happening on my SQL Server Management Studio. When I right-click any table, I get a "VIEW SERVER STATE permission was denied on object 'server', database 'master'. (.Net SqlClient Data Provider)" error, but if I just click OK, then the context menu appears and I keep working just the same. Again, if I right-click in Columns, Keys, whatever, inside the table, everything works fine. Any ideas??

migrated from stackoverflow.com Jul 9 '15 at 17:01

This question came from our site for professional and enthusiast programmers.

  • 1
    Run the profiler to see what is executing to cause that error. SQL Server permissions are a bitch of note to get right. – leppie Jul 9 '15 at 14:13
  • If I remember right, you might get this error if the SSMS isn't patched to the latest service pack, but I don't recall the specific version/SP combo. – Dan Guzman Jul 10 '15 at 1:44
  • I encountered this after a database version upgrade. Solution was to install new version of SSMS to match new DB version. – Danny Varod Dec 1 '15 at 9:36
  • Same issue with one of our users using SQL 2012 SSMS to connect to SQL 2014 DB. When right-clicking on view, he got the same error and granting db_owner to the database in question or even master didn't help. I found that by granting "processadmin" server role, the error went away. No idea why. There is probably a less privileged permission I could grant but haven't found it. – Aaron Nov 3 '17 at 16:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.