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 showingNot 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