Skip to content

Security API issues

VIEW SERVER STATE permission was denied

Problem

The service account does not have View Server State permissions on the SQL Server. This error is related to the requirement on earlier versions of security of having this permission. The complete error message is:

  • Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: VIEW SERVER STATE permission was denied on object 'server', database 'master'.

Solution

Provide the View Server State permission to the Active Roles service account.

From the SQL Server Management Studio via GUI:

  1. Connect to the SQL instance
  2. Navigate to Security | Logins
  3. Right Click the ARS Service Account | Select Properties
  4. Select the Securables page
  5. In the bottom pane, scroll to the bottom and Grant - View Server State

From the SQL Server Management Studio via statement:

  1. Connect to the SQL instance
  2. Select New Query
  3. Use the following statement: GRANT VIEW SERVER STATE TO "AccountName"

Related information

This issue is no longer applicable in newer versions as access to master database is not required.

Problem

You get the following exception as in some AWS deployment: MailKit.Security.SslHandshakeException: An error occurred while attempting to establish an SSL or TLS connection

Solution

You should change "SecureSocketOptions" to None.