Hi guys,
Can anyone please assist with the following error that I received in SCOM:
Management Group: Wyrm. Script: DiscoverSQL2014MirroringWitness.vbs. Version: 6.7.2.0. Instance: PRD01 : Mirroring witness discovery script 'DiscoverSQL2014MirroringWitness.vbs' for instance '<InstanceName>' failed. The next errors occured: Query execution failed: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The SELECT permission was denied on the object 'database_mirroring_witnesses', database 'mssqlsystemresource', schema 'sys'.
Can someone direct me as to how to fix this?
Regards
IC