crystalempress
Programmer
Running Reporting Serives on Sql 2005, Windows Server 2003. Just got Reporting Services up and runnning. Now when I run one of the reports I get the error:
Server Error in '/Reports' Application. This report is based on a stored procedure. Has worked in the past, but not since we switch to a new server. Works in the Developement (Visual Studio 2005), Stored proc works independently on the SQL Server.
Following is the detailed error message:
*********************************************************
*********************************************************
Server Error in '/Reports' Application.
-----------------------------------------------------------
For more information about this error navigate to the report server on the local server machine, or enable remote errors
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: Microsoft.Reporting.WebForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors
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:
[ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]
[ReportServerException: An internal error occurred on the report server. See the error log for more details. (rsInternalError)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +286
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +109
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +321
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
---------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
*********************************************************
*********************************************************
Any clues?
Thanks
Server Error in '/Reports' Application. This report is based on a stored procedure. Has worked in the past, but not since we switch to a new server. Works in the Developement (Visual Studio 2005), Stored proc works independently on the SQL Server.
Following is the detailed error message:
*********************************************************
*********************************************************
Server Error in '/Reports' Application.
-----------------------------------------------------------
For more information about this error navigate to the report server on the local server machine, or enable remote errors
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: Microsoft.Reporting.WebForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors
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:
[ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]
[ReportServerException: An internal error occurred on the report server. See the error log for more details. (rsInternalError)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +286
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +109
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +321
Microsoft.Reporting.WebForms.HttpHandler.GetHandler() +508
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
---------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
*********************************************************
*********************************************************
Any clues?
Thanks