Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. The Foglight user may still not be able to read data from these read-only replicas even if the users are synchronized. (4227786)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. The Foglight user may still not be able to read data from these read-only replicas even if the users are synchronized.
Description

Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. The foglight user may still not be able to read data from these read-only replicas until the users will be synchronized.
Resolution

WORKAROUND 1

After granting the permission fails, re-monitor this instance again, this should monitor successfully.

WORKAROUND 2

Grant the permissions manually

STATUS

This issue has been logged as SSFOG-1207 and is listed as a known issue in the SQL Server cartridge release notes.
Defect ID

SSFOG-1207

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Databases on a secondary replica are read-only, so the grant script cannot create the user in the database. The Foglight user may still not be able to read data from these read-only replicas even if the users are synchronized. (4227786)

Title

Description

Resolution

Defect ID

Leave a Comment