Post reply

Can''t connect to Reporting Services through SQL Server Management Studio And IIS

  • August 3, 2007 at 6:59 am

    #179965

    Hi,

    I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does.

    I'm running SQL 2005 Enterprise 64bit with Service Pack 2.

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

    Cannot connect to ctbbcysql02.

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

    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()

    Any help will be greatly appreciated.

    Regards,

    Ruaan

  • August 3, 2007 at 7:14 am

    #724489

    is your web server up and running

    Everything you can imagine is real.

  • August 3, 2007 at 7:20 am

    #724494

    Yes, but when I go to default sites -> reportserver- right click -> browse I can a page that displays Service Unavailable.

  • August 5, 2007 at 7:52 am

    #724728

    OK, let me put it this way. What group policy objects will effect Reporting Services?

  • August 5, 2007 at 8:10 am

    #724729

    Ruaan,

    If you go to the RS configuration manager are you able to connect to your RS server?

    Everything you can imagine is real.

  • August 6, 2007 at 12:12 am

    #724756

    Is this a fresh install or an older install that used to work and no longer does?

     

  • August 6, 2007 at 1:57 am

    #724763

    If I use the RS Configuration manager I can connect without problems.

    The install was a fresh install, no upgrades from previous versions.

  • August 6, 2007 at 6:10 am

    #724802

    check that the ASPNET user has read, execute,list permissions on the folder [C:\Program Files\Microsoft SQL Server\...\Reporting Services] and its child folders.

    Everything you can imagine is real.

  • August 6, 2007 at 7:05 pm

    #724985

    If I've read this correctly, you should also be able to recreate/reset the permissions, etc. for your reporting services instance via the Reporting Services Configuration Manager.  Go to the console, select the instance, and then check the "apply default settings" for both the Report Server and Report Manager virtual directories.

    Joe

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy