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.