unable to connect to the Report Server WMI privider when I try to connect a report server

• rajeeshuna

  Grasshopper

  Points: 13

  More actions

  November 16, 2010 at 1:33 pm

  #228895

  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

• getoffmyfoot

  Hall of Fame

  Points: 3338

  More actions

  November 17, 2010 at 6:01 am

  #1251845

  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.

• surbajit.shehri

  SSC Journeyman

  Points: 78

  More actions

  November 19, 2010 at 8:38 am

  #1253096

  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