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.
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center