VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ . (Microsoft SQL Server, Error 300)

Error Message :

Solution 1:

Launch SQL Server Management Studio.

Connect to the SQL Server Instance.

Navigate to Security folder then expand Logins

Right Click at your login name and choose Properties

Click at Securables tab from left side pane

In the bottom pane, scroll to the bottom and click at Grant option for View Server State value.

Now click on apply to close the window. You can now ask your user to test the script again. This time it will work

Solution 2:

Using SQL script

USE MASTER

GO

GRANT VIEW SERVER STATE TO [username]