Search code examples
sql-serverpermissionssystem-databases

sql view server state permission was denied

I just installed SQL server 2014 however, I have a problem creating the database or even view properties.

I get "VIEW SERVER STATE permission was denied on the object 'server', database 'master'. Microsoft Server, Error:300"

I cannot alter my server roles, I have only "Public" role for some reason. any ideas?

Solution

  • Just for reference, this problem seems to be related to this bug.

    I have the same problem with SQL Server Management Studio 2012.

    If anyone finds stuck with this problem, try to update the SQL Server Management Studio. This way, you don't need to grant the permission VIEW SERVER STATE to the user.

    Using SQL Server Management Studio 2014 (12.0.4213.0) now, and the problem seems to be gone