November 16, 2010 at 1:33 pm
I am very new to SSRS and just started to do one report on from last Friday
My problem looks bit strange
My report server is in another computer and can create, execute and edit reports and models in that server. The version of report server is 2005 (the reporting server and SQL server 2005 database are in same mcahine)
In my machine, I have SQL server 2008 and I am trying to connect ablve mentioned Report server. However, it is throwing following error
"unable to connect to the Report Server WMI privider
Details:
The RPC service is unavailable
"
My machine is Windows 7 and the reporting server OS is Windows Server 2003
Any help on this would be great
November 17, 2010 at 6:01 am
What tool are you using to connect to SSRS and write reports? BIDS or Report Builder?
I have 2 suspicions -
1. Default report server site isn't properly configured
- in report builder its under menu>options>settings>use this report server or sharepoint site by default:
- in BIDS its under project>properties>general>targetserverurl:
in either case you should put the target report server's catalog url, which is usually in the format http://<server>/ReportServer
If you have the url set correctly, I'd probably suspect you are facing a network issue possibly related to a firewall or proxy.
November 19, 2010 at 8:38 am
Hi,
You might want to check the connection level setting in the report server config file;
it seems like this is set to 2 which requires SSL cert to connect.
Set this to 0 (zero)
Regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply