December 8, 2016 at 12:34 am
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
December 8, 2016 at 3:51 am
If you have dedicated SCOM action account for SQL server then you need to give permissions for this account on your witness server. If you use default account, try to check that your "NT AUTHORITY/SYSTEM" account have all needed permissions on witness server.
BTW, have you got any authentication errors in your SQL server log?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply