question

adilahmed avatar image
0 Votes"
adilahmed asked adilahmed commented

VIEW SERVER STATE permission was denied on object 'server', database 'master'. error in SharePoint 2016 Farm.

HI
I prepared New SP 2016 Farm with 4 Servers
App1 - MinRole (Application + Search)
App2 - Distributed Cache
WFE1 - Custom Role (Running Microsoft SharePoint Foundation Web Application)
WFE2 - Custom Role (Running Microsoft SharePoint Foundation Web Application)

In App1 below error keep throwing every time. Unknown SQL Exception 300 occurred. Additional error information from SQL Server is included below.

VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action.

office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered adilahmed commented

Hi @adilahmed,

I want to confirm with you that what operations were you executing when this error appeared and Did this error cause any features of your SharePoint to be missing?

Firstly please take a reference to the following solution to provide the View Server State permission to the SharePoint service account.

  • Access SQL Server Management Studio via GUI

  • Connect to the SQL instance

  • Navigate to Security | Logins

  • Right Click the SharePoint Service Account | Select Properties

  • Select the Securables page

  • In the bottom pane, scroll to the bottom and Grant - View Server State


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@adilahmed,

Is there any update on this thread? I'm looking forward to your reply.

0 Votes 0 ·

HI also we prepared the DR Separate farm with 2 Servers one App & one WFE,
SQL Server level we prepared SQL Server Always on with two SQL Nodes one in DC and another one in DR, and we created one AGLISTNER

we are using this AG listener as connection string for DC and DR Separate SharePoint farms and we are Sync or Replicate SP Content Databases to DR.
Now when we do the AG failover to DR in DC SharePoint farm i saw above mentioned errors.

0 Votes 0 ·