Retour
-
Titre
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.
-
Résolution
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.
-
Identifiant du défaut
SSFOG-1207