July 13, 2009 at 11:38 am
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
January 11, 2010 at 9:17 am
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)
January 14, 2010 at 4:05 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply