Hi,
the mssql.vbs script is by default executed by the user “local system” that the checkmk agent is running with. In most cases this just works out-of-the-box.
If this does not work, you have at least three choices:
- Edit permissions for the local system account to connect to the database (see links)
- Enter database credentials for a database user (they will be stored in cleartext in the config files)
- change the logon account of the checkmk agent service to a user that has access to the database
- Maybe change the permissions of the plugin to a group user that has access to the database
Some info about the needed permissions :
https://kb.checkmk.com/display/KB/MSSQL+permissions
https://kb.checkmk.com/display/KB/Minimal+database+permissions+for+the+agent+plug-in+mssql.vbs
If you don´t know how to edit or find out how to set the necessary permissions, you should talk to the DBA of that system to help you.
As there is currently a huge bug in the code of the mssql.vbs, i would recommend to use 2.1p19 and in case of v2 wait for the 2.0p33, or use the newest versions from the git repo.