pjtaylor


I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure.

Anyone got any pointers



Re: Report Server First Time Configuration: Provider Load Failure

Buck Woody


You're using Express





Re: Report Server First Time Configuration: Provider Load Failure

pjtaylor

Yes




Re: Report Server First Time Configuration: Provider Load Failure

Mike Wachal - MSFT

Moving to RS forum.

Mike






Re: Report Server First Time Configuration: Provider Load Failure

pjtaylor

Can anyone help me out on this



Re: Report Server First Time Configuration: Provider Load Failure

Prash Shirolkar - MS

This maybe due to issues with the Reporting Services WMI Provider.

Can you make sure you have a ReportingServicesWMI.dll present and of the appropriate version wrt to the config tool

thanx,
Prash






Re: Report Server First Time Configuration: Provider Load Failure

RemiL

I have the same issue on SQL Server 2005 SP2 - the dll version is correct - I re-installed SQL Server and it's still broken.

WMI service is running - everything else works.




Re: Report Server First Time Configuration: Provider Load Failure

RemiL

Well I figured out my problem, the System PATH variable was missing

C:\windows\system32\wbem

I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path.





Re: Report Server First Time Configuration: Provider Load Failure

Jeethendar

Can you please provide more detail about the solution. I am also facing this problem.




Re: Report Server First Time Configuration: Provider Load Failure

RemiL

Well, there isn't much more to say - make sure %WINDIR%\system32\WBEM is in your PATH. If it is not, the WMI provider library (which depends on FRAMEDYN.DLL) cannot be loaded. (the alternative would be to copy FRAMEDYN.DLL into the directory that has reportingserviceswmi.dll but I would not recommend it)

Some application messed up my PATH variable and the Reporting Services WMI provider would not load. The error handling could be better so we don't have to debug the process to figure it out...





Re: Report Server First Time Configuration: Provider Load Failure

K9

Remill: Thanx, I have spent over half the day looking for the problem, and now it is fixed. You would have thought that MS could have gotten rid of the PATH thing along time ago. Oh Well.

Thanx