468,733 Members | 1,622 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

Report Server Visual Studio

I am trying to set up a Report Server to publish reports that I have created
in Visual Studio 2005. I have been able to get it up and running and I am
able to access reports via the web and set up another user. The other user
can log on and see the reports available but when he runs then it begins to
run the report then throws the error below. I have tried looking in the
virus software logs to see if it is being blocked but that doesn't seem to be
the problem. Any help would be greatly appreciated. Thanks.
Server Error in '/Reports' Application.
________________________________________
An established connection was aborted by the software in your host machine
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.Sockets.SocketException: An established
connection was aborted by the software in your host machine

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:

[SocketException (0x2745): An established connection was aborted by the
software in your host machine]
System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32
size, SocketFlags socketFlags) +1043387
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32
size) +119

[IOException: Unable to read data from the transport connection: An
established connection was aborted by the software in your host machine.]
System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32 size) +386
System.Net.HttpWebRequest.MakeMemoryStream(Stream stream) +221

[WebException: The underlying connection was closed: An unexpected error
occurred on a receive.]

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.GetSecureMethods() +211

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.IsSecureMethod(String methodname) +42

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.GetExecutionInfo() +122
Microsoft.Reporting.WebForms.ServerReport.GetExecu tionInfo() +234
Microsoft.Reporting.WebForms.ServerReport.SetExecu tionId(String
executionId, Boolean fullReportLoad) +109

Microsoft.Reporting.WebForms.ServerReport.LoadFrom UrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation.. ctor() +326
Microsoft.Reporting.WebForms.HttpHandler.GetHandle r(String operationType)
+470
Microsoft.Reporting.WebForms.HttpHandler.ProcessRe quest(HttpContext
context) +44

System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +64

Oct 13 '07 #1
1 2056
Hi,

Mmmm... not sure if it's an SSRS issue or a datasource / connection string
issue.

Let's first check where is the source of the problem:

- Create a dummy report with a label (content e.g.: 'Test') and no
datasrouce/Connection database at all.

- Publish this report.

- Try to browse the report with both users.

Did the report work?

- Yes: Then it's a datsource issue, go to the datasources folders and edit
the connection string associated to the other reports (99 % that you are
using Windows Authentication, try to setup a SQL Server login for the
connection and store it, perform all this operations in the SSRS Navigator).

- No: Uh uh... it seems that your SSRS instance is not well installed :-(,
check first SQL Server Configuration and see if any of the settings is not
correctly initialized.

Good luck
Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"chairman" wrote:
I am trying to set up a Report Server to publish reports that I have created
in Visual Studio 2005. I have been able to get it up and running and I am
able to access reports via the web and set up another user. The other user
can log on and see the reports available but when he runs then it begins to
run the report then throws the error below. I have tried looking in the
virus software logs to see if it is being blocked but that doesn't seem to be
the problem. Any help would be greatly appreciated. Thanks.
Server Error in '/Reports' Application.
________________________________________
An established connection was aborted by the software in your host machine
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.Sockets.SocketException: An established
connection was aborted by the software in your host machine

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:

[SocketException (0x2745): An established connection was aborted by the
software in your host machine]
System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32
size, SocketFlags socketFlags) +1043387
System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32
size) +119

[IOException: Unable to read data from the transport connection: An
established connection was aborted by the software in your host machine.]
System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32 size) +386
System.Net.HttpWebRequest.MakeMemoryStream(Stream stream) +221

[WebException: The underlying connection was closed: An unexpected error
occurred on a receive.]

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.GetSecureMethods() +211

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.IsSecureMethod(String methodname) +42

Microsoft.SqlServer.ReportingServices2005.Executio n.RSExecutionConnection.GetExecutionInfo() +122
Microsoft.Reporting.WebForms.ServerReport.GetExecu tionInfo() +234
Microsoft.Reporting.WebForms.ServerReport.SetExecu tionId(String
executionId, Boolean fullReportLoad) +109

Microsoft.Reporting.WebForms.ServerReport.LoadFrom UrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +90
Microsoft.Reporting.WebForms.ReportDataOperation.. ctor() +326
Microsoft.Reporting.WebForms.HttpHandler.GetHandle r(String operationType)
+470
Microsoft.Reporting.WebForms.HttpHandler.ProcessRe quest(HttpContext
context) +44

System.Web.CallHandlerExecutionStep.System.Web.Htt pApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean&
completedSynchronously) +64
Oct 13 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Stephan | last post: by
2 posts views Thread by | last post: by
reply views Thread by lekshmi.raju | last post: by
3 posts views Thread by Trimtrom | last post: by
8 posts views Thread by Ryan | last post: by
reply views Thread by zhoujie | last post: by
xarzu
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.