CODEWITHSUNDEEP
sql-serverpermissionssystem-databases
Mindan
Mindan

Reputation: 1019

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?

Upvotes: 21

Views: 80469

Answers (3)

EeNiArT
EeNiArT

Reputation: 70

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

Upvotes: 3

Ramkumar Sambandam
Ramkumar Sambandam

Reputation: 557

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

USE MASTER
GO
GRANT VIEW SERVER STATE TO [username]

Upvotes: 31

Mukesh Modhvadiya
Mukesh Modhvadiya

Reputation: 2178

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>

Upvotes: 3

Related Questions