Werk #19197: mk-sql: ODBC backend now supports SQL Server authentication

Component

Checks & agents

Title

mk-sql: ODBC backend now supports SQL Server authentication

Date

Apr 23, 2026

Level

Prominent Change

Class

New Feature

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.5.0p1	Checkmk Community, Checkmk Pro, Checkmk Ultimate, Checkmk Cloud, Checkmk Ultimate MT

Previously, the mk-sql ODBC backend always used Windows Integrated Authentication (SSPI) regardless of the authentication type configured in the agent configuration. SQL Server credentials were silently ignored when connecting via ODBC, which meant that SQL Server authentication did not work for local ODBC connections.

Starting with this release, the ODBC connection string is built from the configured authentication type. SQL Server authentication (UID/PWD) is now correctly passed through to the ODBC driver. Additionally, sensitive credentials are redacted from log output to prevent accidental exposure in log files.

To the list of all Werks