<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12"> <TITLE>check_mssql_health connection problem</TITLE> </HEAD> <BODY>  Hi there -- I have completed the installation of the check_mssql_health plugin onto a Nagios 3.2.3 64-bit server running on the CentOS 6.0 distribution. When I try to connect to a remote server running MSSQL Server 2008 R2, the following command syntaxes are used: ./check_mssql_health --server=<fully qualfified domain name> --username=<username> --password=<password> --mode=connection-time ./check_mssql_health --hostname=<fully qualfified domain name> --username=<username> --password=<password> --mode=connection-time The error message that I am receiving is the following: CRITICAL - cannot connect to <fully qualified domain name>. DBI connect(';server=<fully qualified domain name>',<username>',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (41) Server <fully qualified domain name>, database Message String: Server is unavailable or does not exist. at ./check_mssql_health line 2175 I have confirmed the hostname of the SQL server, as well as username and password to access the database. The syntax for the username was either <username> or <domainname>\username during the testing. The port of the server is the default port which, if I am not mistaken, is port 1433. I have tried several sql modes with the same error message appearing each time. Can someone lend a hand here? Thanks. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.</BODY> </HTML>