DBSS - Database Mirroring Role requires user account with with sysadmin role.
Using SQL Server management Console
- Connect to SQLServer using as Foglight user, run the following query:
select * from sys.database_mirroring
or
select s.name , m.* from sys.database_mirroring m, sys.databases s where m.database_id = s.database_id
- Check IsMirroring metric based on sys.database_mirroring if there is a non-NULL values on a mirror
e.g check the columns mirroring_guid, m.mirroring_state, mirroring_state_desc
- Navigate to Security | Logins | check if the sysadmin server role is given.
- Restart DBSS agent
Further details about required permissions are here.