Search This Blog

Not able to open any SSRS Reports in Share Point Integrated Mode through SharePoint Website

Not able to open any SSRS  Reports in Share Point Integrated Mode through SharePoint Website

Today I faced a Issue in my Server when i opened any report from my share point website it was showing
Not able to connect to Report Server in Share Point Integrated Mode Before that all report were working in share site but today when  i open the reports from share point site its showing
Unable to connect to the remote server
No connection could be made because the target machine actively refused it.
Below is the Screen Shot of the Error for all the Reports it was showing Same Error.





I tried to open report using report builder its not working then i download the report and through report builder i opened
the error was cannot connect to report server.
and when i copied thre report server  link into browser the link is working fine.

Solution
 I googled it for 2 hours but didn't get any solution i checked Report server the server was updated one day
So my system admin told me that after updation the report server has taken default setting as in the Server it was showing some WMI error.
In order to Resolve this

copy file sqlmgmproviderxpsp2up.mof from
 C:\Program Files (x86)\Microsoft SQL Server\100\Shared
 and paste it into C:\Program Files\Microsoft SQL Server\100\Shared
: open elavated cmd and type
 mofcomp.exe
 "C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
 press enter key

Restart the Server.

I want to say if you ever face this kind of issue follow above steps and  restart your server.
.

No comments:

Post a Comment