Reporting Services Logon Error

  • Hello,

    I'm getting the following error when attemption to login to SSRS through management studiol

    The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.sqlServer.management.ui.rsclient)

    Any help would be greatly appreciated.

    Thanks,

    Jkearns

  • Hi,

    you may already have resolved this, but I got the same error today and resolved it by allowing script execute permissions on the virtual directories.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • If you then scan the recent logfiles in C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles and find the following exception: Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: .

    it means that you have configured the /reportserver/ app to not be reachable via http://localhost/... - there are two options from here:

    1) add the localhost hostheader to the web-site which hosts the /reportserver/ and make sure the app is then reachable via that path

    2) edit the file C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\RSWebApplication.config and add the full url to the ReportServer into the ReportServerUrl tag (no ending / nessesary) AND remove the value from ReportServerVirtualDirectory (otherwise you get nasty, unprecise exceptions). THEN you must recycle the app-pool used by the Report-Manager so that config file is being reloaded.

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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