Werk #2472: MSSQL Agent Plugin: Can now be configured to auth as database user

Component Checks & agents
Title MSSQL Agent Plugin: Can now be configured to auth as database user
Date Jul 21, 2015
Level Trivial Change
Class New Feature
Compatibility Compatible - no manual interaction needed
Checkmk versions & editions
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3
Not yet released
Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)
1.2.7i3 Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk MSP (CME)

The mssql.vbs script can now be configured to authenticate as database user using a configured username / password combination. Previously it was only possible to authenticate using the system privileges of the user the agent is running with. This is still the default.

If you need to authenticate as database user, you need to create a file named mssql.ini, or if you need it instance specific, mssql_[instance-id].ini. You need to write the following content into this file:

mssql.ini

[auth]
type = db
username = monitoring-user
password = mysecretpw

To the list of all Werks