Error, "VIEW SERVER STATE permission was denied on object 'server', database 'master'" on SQL Server 2016 database (4229549)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error, "VIEW SERVER STATE permission was denied on object 'server', database 'master'" on SQL Server 2016 database
Description

The following error occurs when adding a new SQL Server 2016 database:
VIEW SERVER STATE Permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. [300]
Cause

The View Server State permission is not set for the Diagnostic Server service account.
Resolution

SOLUTION:
From the SQL Server Management Studio via GUI:
Log in as the SA Admin User in SSMS.
1. Connect to the SQL instance.
2. Navigate to Security | Logins
3. Right-click the Diagnostic Server Service Account | Properties.
4. Select the Securables page.
5. In the bottom pane, scroll to the bottom and Grant - View Server State and click OK
From the SQL Server Management Studio via statement:
1. Connect to the SQL instance.
2. Select New Query.
3. Use the following statement:
USE MASTER
GO
GRANT VIEW SERVER STATE TO <DiagnosticServerUserName>

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title