Hi Andreas
The agent runs with NT authority\system please check which rights it has in the SQL instance. To do this in MSSQL Studio right click on the top of the instance - Security - The user needs at least an additional Connect to any DB.
With check_mk_agent test you can check if the plugin is also executed by the CheckMK agent.
BR,
Simon