reporting-services - SQL Reporting Services，请求失败，HTTP 状态为 404 : Not Found

Question

.net 应用程序在 SQL Server 2005 的服务器上运行，现在我们将应用程序重新定位到新服务器，即 SQL Server 2008。

以下是我尝试从应用程序获取报告时的错误:

Server Error in '/Importal' Application.

The request failed with HTTP status 404: Not Found. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 404: Not Found.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[WebException: The request failed with HTTP status 404: Not Found.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +431225
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204
Microsoft.SqlServer.ReportingServices2005.Execution.ReportExecutionService.LoadReport(String Report, String HistoryID) +69
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +67

[MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.]
Microsoft.SqlServer.ReportingServices2005.Execution.MissingEndpointException.ThrowIfEndpointMissing(WebException e) +4027725
Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +107
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +121
Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) +67 ImportPerformanceKPI.btnList_Click(Object sender, EventArgs e) +425
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Answer 1

如果您的新 SQL Server 尚未配置，您将需要配置 Reporting Services。你可能已经做到了。

在错误中，我们有:

[MissingEndpointException:尝试连接到报表服务器失败。检查您的连接信息以及报表服务器是否为兼容版本。 ]

接下来确保您的应用程序指向 SQL Server 的新实例(它正在寻找 2005 实例)。然后检查您的应用程序是否适用于 SSRS 2008。