Nagios monitor MSSQL with Force encryption

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
sidvisid
Posts: 1
Joined: Mon Sep 14, 2020 12:22 am

Nagios monitor MSSQL with Force encryption

Post by sidvisid »

Hi Everyone,
i use check_mssql_health to monitor My MSSQL server. after i implement MSSQL With PKI Certificate and enable force encryption. i cannot run check_mssql_health anymore.

error following below.
#######
CRITICAL - cannot connect to (My server ip). DBI connect(';server=(My server ip)','nagios',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (49)
Server (My server ip), database
Message String: Unexpected EOF from the server
OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (34)
Server (My server ip), database
Message String: Adaptive Server connection failed
at ./check_mssql_health line 2131
#######

Do you have anyidea to solve this case.
Locked