One of our customers approached us with SQL error 300. He complained that he was not able to execute some of the queries and facing “VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’ . (Microsoft SQL Server, Error 300) ” error while executing a script.
Here, this error occurs if the script doesn’t have VIEW SERVER STATE permission.
Here at Bobcares, we have seen several such SQL-related issues as part of our Server Management Services for web hosts and online service providers.
Today we’ll take a look at how to fix this error.
How we fix SQL error 300
Now let’s take a look at how our Support Engineers resolve this error for our customers.
Since the script doesn’t have VIEW SERVER STATE permission, we can fix this error by granting permissions to the login name.
We can assign the permissions using two ways. Here are they:
1. Assigning permissions using GUI in SQL Server Management Studio
1. First, we launch SQL Server Management Studio.
2. Next, we connect to the SQL Server Instance.
3. After that, we navigate to the Security folder and expand Logins.
4. Then we right-click at our login name and choose Properties.
5. Here, we click on the Securables tab from the left side pane.
6. In the bottom pane, we scroll down and click on the Grant option for View Server State value.
7. Finally, we click on apply to close the window. We can now ask our user to test the script again. This time it will work.
2. Assigning permissions using T-SQL statement in SQL Server Management Studio
1. First, we launch SQL Server Management Studio and connect to the SQL Server Instance.
2. Next, we open the New Query window
3. Then we run the below T-SQL statement:
USE master GO GRANT VIEW SERVER STATE TO “LoginName”
Once we execute the above command, we will have to view server state permission on our login name.
[Need any further assistance in fixing SQL errors? – We’re available 24*7]
Today, we saw how our Support Engineers resolve this SQL error.