sql view server state permission was denied

Question

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?

Answer 1

connect to ssms using administrator(sysadmin) account and execute the below

USE MASTER
GO
GRANT VIEW SERVER STATE TO [username]

Answer 2

From SQL Server Expert

Login user do not have VIEW SERVER STATE permission and granting the required permission solves the issue.

USE MASTER
GO
GRANT VIEW SERVER STATE TO <username>

Answer 3

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