check_mssql_health connection problem

[Kaplan, Andrew H.]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20111024/331cb4d4/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning at Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null