Keep getting "The target database, '%', is participating in an availability group and is currently not accessible for queries" when monitoring AlwaysON Availability groups with the SQL Server Management Pack

Question

_{Monday, May 9, 2016 5:20 PM}

We just implemented SCOM and when we added the SQL Server management pack on our SQL Server 2012 and 2014 with AlwaysON Availability groups we get the following error on the secondary replicas:

Login failed for <Our Domain>\SQLDiscovery. Full error message follows:

The target database, 'DATABASE', is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access.

How can we manage this error? I would think that the management pack would understand that the secondary replicas can not be queried.

All replies (1)

_{Wednesday, May 11, 2016 8:29 AM ✅Answered}

Hello,

I would like to suggest you configure read-only for those databases to work around this issue.

Here is a similar thread for your reference:

https://social.technet.microsoft.com/Forums/systemcenter/en-US/939c3cbe-193c-4f95-97f1-ac8690c0321a/sql-always-on-not-accessible-for-queries?forum=operationsmanagermgmtpacks

Someone has post this feedback to connect Microsoft site:

https://connect.microsoft.com/WindowsServer/feedback/details/1121330

Regards,

Yan Li

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact [email protected].