Nagios monitor MSSQL with Force encryption
Posted: Mon Sep 14, 2020 12:56 am
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.
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.