Check SQL Database

Troubleshooting
,
1

Hi,

I’m trying to configure a monitor using SQL query on Check SQL Database.
The query is returning the right result on SSMS, but on CheckMK i’m getting the following error on this monitor:

Error while executing SQL command: 102, b"Incorrect syntax near ‘$’.DB-Lib error message 20018, severity 15: General SQL Server error: Check messages from the SQL Server "

I tried change the query to a simplified version like this example:

SELECT 1 AS status_number, ‘OK’ AS status_text;

But i still got the same error.

The SQL server doesn’t have a default instance name, but I’m not sure where and how I should configure the instance. I set it on the field DNS Hostname or IP address as “SERVER\SQLINSTANCE”.

Anyone can help me with this issue ?

CentOS 7
Checkmk Raw Edition 2.1.0p23

Thanks

Check SQL Database
Check SQL Database1910×900 37.7 KB

2

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.