Reporting services 2005 "Service unavailable"

  • HI,

    I could not connect to reporting services through Sql Server management studio and i even when i try the link http://localhost/reports i get the same error as

    Service unavaliable .  Please help

    ===================================

    Cannot connect to PCIDL17775.

    ===================================

    The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

    ------------------------------

    Program Location:

       at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

       at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

       at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

       at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)

       at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()

       at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)

       at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)

       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

     

  • This was removed by the editor as SPAM

  • Use Reporting Service Configuration tool to verify Report Server has intialized.

  • I am having the same problem. It's happening after I installed SP2. Can anybody answer this question?

  • Disabling Loopback checking worked to solve this problem for me:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;896861

    Steve

  • under IIS ,check the Applicaion Pools to see the ReportServer is running.

    My ReportServer is stopped,it worked after i started the ReportServer Pool.

  • I finally figure this out as not a single site could get it right or even get a response. I put this up on my blog (basically a digital remind of things like this that I find.) Let me know if this resolves your problem.

    http://criticalstatus.blogspot.com/

    To connect to a Report Server from Management Studio, there are a few things to consider.

    First, I can not connect to an RS 2000 instance. I'll keep trying. Second, make sure the machine is functional. That really helps too. 🙁 IT can be a real time killer LOL Last, I have read many a sites/posts all of which say use the syntax for a servername as:

    http:///reportserver

    What I found that truly works is http://reports_web_site/reportserver

    * reports web site example --> rptsvrname.yoursite.com i.e. the url you give your report server in IIS.

    * reportserver --> the actual text "reportserver "

    http://criticalstatus.blogspot.com/

  • under IIS ,check the Applicaion Pools to see the ReportServer is running.

    My ReportServer is stopped,it worked after i started the ReportServer Pool.

    Thanks for pointing me in the right direction! For my issue, the AppPool was off but then it turns out that SSRS was accessing the wrong AppPool.

  • Thank you, John.

    Your suggestion worked for me. I've been working on this for almost a week now, trying to fix the 'Service Unavailable' error.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply