We use cookies to ensure that we give you the best experience on our website.  Visit our Privacy Policy to learn more. If you continue to use this site, we will assume that you are okay with it.

Your choices regarding cookies on this site.
Your preferences have been updated.
In order for the changes to take effect completely please clear your browser cookies and cache. Then reload the page.

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

ComponentChecks & Agents
TitleMSSQL Agent Plugin: Can now be configured to auth as database user
Date2015-07-21 15:38:02
Checkmk EditionCheckmk Raw Edition (CRE)
Checkmk Version1.2.7i3
LevelTrivial Change
ClassNew Feature
CompatibilityCompatible - no manual interaction needed

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