Werk #19191: mk-sql: skip inaccessible databases in SQL Server Always On Availability Groups

Component

Checks & agents

Title

mk-sql: skip inaccessible databases in SQL Server Always On Availability Groups

Date

Mar 20, 2026

Level

Prominent Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.5.0b2 Not yet released	Checkmk Community, Checkmk Pro, Checkmk Ultimate, Checkmk Ultimate MT
2.4.0p25 Not yet released	Checkmk Community, Checkmk Pro, Checkmk Ultimate, Checkmk Ultimate MT
2.3.0p46 Not yet released	Checkmk Community, Checkmk Pro, Checkmk Ultimate, Checkmk Ultimate MT

mk-sql previously queried all SQL Server databases indiscriminately, including secondary replicas in Always On Availability Groups (AG) that were not directly accessible. This caused spurious errors when monitoring SQL Server instances participating in an AG.

Now, mk-sql only queries databases that are actually accessible: standalone databases, primary replicas, and readable secondary replicas. Inaccessible AG secondaries are silently skipped — this is expected behavior, not an error.

This change improves monitoring reliability by eliminating false error messages. No configuration adjustments are necessary, as the update is fully automatic and transparent to users.

To the list of all Werks