Reporting Service: Fix the problem of “The attempt to connect to the report server failed.”

2011年3月20日 | 分类: DB | 标签: , ,

   SQL Server 2005 Reporting Service(SSRS 2005),如上一篇文章所述,已解决了部署项目后的访问问题,但是当我输入http://hostname/Reports试图访问Report Manager时,提示信息如下:

 

查看最新日志,C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles,信息如下:

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: Object Not Found.

对此问题,解决方法如下:

到如下路径:C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager,用记事本打开RSWebApplication.config,将<ReportServerUrl></ReportServerUrl>,改成<ReportServerUrl>http://hostname/ReportServer</ReportServerUrl>;<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>改成<ReportServerVirtualDirectory></ReportServerVirtualDirectory>,关闭IE重新打开再输入http://hostname/Reports就能成功连接Report Manager了,页面如下:

Written by Nile Jiang
无猖狂以自彰,当阴沉以自深。

目前还没有任何评论.
注意: 评论者允许使用'@user空格'的方式将自己的评论通知另外评论者。例如, ABC是本文的评论者之一,则使用'@ABC '(不包括单引号)将会自动将您的评论发送给ABC。使用'@all ',将会将评论发送给之前所有其它评论者。请务必注意user必须和评论者名相匹配(大小写一致)。