Our Environment:

1 Server Containing Reporting Services in Production

1 Server Containing Reporting Services in BCP (failover server)

Clustered Shared Point servers running 2003

Latest RS Extension

I created a simple report and have has no issues running it on my local machine. I am providing my credentials in the data source and they have access to the list.

I then configured our BCP Reporting Server using the directions provided, and deployed the report. It works great there!

Then I configured our production Reporting Server the exact same way as BCP and deployed the report. Now when I try to execute the report from Production I get the following error: “An error has occurred during report processing” and it gives no other information. Just this 1 error.

I then looked in the logs and saw this:

Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing.

w3wp!webserver!6!03/23/2007-12:35:30:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing.

w3wp!library!6!3/23/2007-12:35:40:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

w3wp!library!7!03/23/2007-12:39:14:: i INFO: Call to GetPermissions:/Workflow Reports/IdM Prioritized Request List

w3wp!library!7!03/23/2007-12:39:14:: i INFO: Call to GetSystemPermissions

w3wp!library!1!03/23/2007-12:39:15:: i INFO: Call to RenderFirst( '/Workflow Reports/IdM Prioritized Request List' )

w3wp!processing!1!3/23/2007-12:39:36:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'Tasks'., ;

Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'Tasks'. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)

at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

--- End of inner exception stack trace ---

at System.Net.HttpWebRequest.GetRequestStream()

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Enesys.ReportingServices.SpExtension.WssLists.Lists.GetListCollection()

at Enesys.ReportingServices.SpExtension.xfc52622414cfea39.x93d236a68267196e(XmlNode x2c1f549d43527566, String x7472fd0c7aee978b, Lists x0e3dc4e8246723b4, DataParameterCollection xf4367403ed9265da)

at Enesys.ReportingServices.SpExtension.Command.x5a9951e7e8383c8d(Boolean xbb3fbbd33e2afaca)

at Enesys.ReportingServices.SpExtension.Command.ExecuteReader(CommandBehavior behavior)

at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()

I can’t seem to find a reason why the report works in BCP and not in Production. They all reside in the same domain. I have compared the environments, and everything is then same.

Any ideas on what could be the issue?