MSSQL CRITICAL - Error: Provider cannot be found. It may not be properly installed

[Minh R.]

> Leif J. <nagios <at> ljnet.dk> writes:

> 
> 
>     On a brand new Windows 2008R2 and MSSQL 2008R2 I have installed
>     NSClient++ and put check_mssql_nt but when I try to connect to the
>     localhost I'm getting: MSSQL CRITICAL - Error: Provider cannot
>       be found. It may not be properly installed
>     What can it be ? I have looked several sites and have not yet
>     figured it out why.
>     /Leif
> 
> 
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today
> http://p.sf.net/sfu/msIE9-sfdev2dev
> 
> _______________________________________________
> 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


I'm having the same issue. I have added the check_mssql_nt.exe file to the 
\NSClient++\scripts\ folder, un-commented the NRPEListener.dll in the nsc.ini 
file, allowed arguments under "COMMAND ARGUMENT PROCESSING" in the nsc.ini file, 
and added the following line to the "[External Scripts]" section of my client 
server's NSC.ini file:

check_mssql_connection=scripts\check_mssql_nt.exe /H:$ARG1$ /D:$ARG2$ /U:$ARG3$ 
/P:$ARG4$

Then I run the following command from the Nagios server as a test:

./check_nrpe -H sqlservername -c check_mssql_connection -a sqlservername 
sqldatabasename username password

The error returned is:

MSSQL CRITICAL - Error: Provider cannot be found. It may not be properly 
installed

Does anyone have any ideas?


------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
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