MSSQL Critical error

[reincarne]

Hi,
We are trying to monitor some queries. It did work on with SQL 2005, once we upgraded it we received an error below:
MSSQL CRITICAL - Error: Provider cannot be found. It may not be properly installed

P.S: We upgraded to SQL 2008 R2.
One of the solutions that were suggested to us is to install native client 2005, which is not possible as our native client is 2008.
I'm sure there is a solution, I just don't know what to look for.

Thanks

[scottwilkerson]

Not sure what plugin you are using, but I found a resolution to a similar problem in the reviews here
http://exchange.nagios.org/directory/Pl ... nt/details

It works as expected but does not work out of the box on Windows 2008 R2. In order to get past the "MSSQL Critical - Error: Provider cannot be found..." you need to install the SQL Server 2005 SQL Native Client. This can be found here: http://www.microsoft.com/en-us/download ... x?id=17943

The problem basicly is that check_mssql_nt looks for SQLNCLI.1 but on Windows 2008 R2 this has been replaced by SQLNCLI10.1. By installing the SQL Server 2005 SQL Native Client the SQLNCLI.1 version is added so that the plugin can use it.