MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m)

[ybcnyc]

Hi,

I'm having issue getting Zabbix (latest version) to monitor MSSQL

It won't fetch any data. I realized that i need to ODBC Driver 17 for SQL Server + mssql tools which i installed.

i'm able to connect to sql server with

sqlcmd -C -S <SQLSERVER> -U user -P pass

However as you can see i have to specify -C flag TrustServerCertificate. Is there a way to tell zabbix to pass it to the command when it's polling the server in host configuration ? I tried entering TrustServerCertuficate=Yes / True in /etc/odbc.ini but it fails unless I specify the -C flag

sqlcmd -S <SQLSERVER> -U user -P pass

Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificat e verify failed:self signed certificate].
Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.

Any advice is appreciated. I'd like to monitor all DBs on the server. So the question is is there a way to specify TrustServerCertificate globally or somewhere in the host config ?

My MSSQL server is not forcing encryption. I'm able to sqlcmd -S <SQLSERVER> -U user -P pass from a Windows box fine.

Thanks