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]