Alternative explantations for "provider failure" with MS SQLServer plug-in.
I am attempting to set up the SQL Server plugin. After much messing about, I have got to the stage where the agent can connect to the sql server, but all the metric collection queries show an 0x80041004 error.
e.g.
em_error='SELECT name,sqlservername,initialsize,spaceavailable,lastbackup FROM mssql_transactionlog WHERE sqlservername ='(local)'' query execution failed. Error code = 0x80041004 em_error=An error has occured while fetching WMI data.
According to Microsoft Technet, this error number means ' WMI Provider Failure' and can occur if the user querying the WMI is a local user 'created since the WMI service was started'. There is apparently a hotfix for this, but workaround ( restart the WMI service) is not effective so I have doubts that the technet note applies to my situation.
Has anyone seen this problem and solved it?
Agent version:10.2.0.3
Windows Version: 2000 SP4
Sql Server Version: 2000 (8.00.2309)
Plugin version: 3..1.3.1.0
Message was edited by:
smitjb