SQL Reporting 2008 save report error message

Posted on 2009-04-27
Last Modified: 2012-08-13

Whenever I try to save any report in report builder 2.0 I get the following error message:

An established connection was aborted by the software in your host machine
Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
The underlying connection was closed: An unexpected error occurred on a send.

If the database that the report takes it's reporting data from is on the same server as the reporting database I do not get this error, only if it is on a different server.

I'm assuming this must a permission issue, so my question is.

A.  Is there an error log or a trace file I can use to track this?
B.  Does anyone know specifically what this problem could be?

Question by:kinton
    LVL 26

    Expert Comment

    by:Chris Luttrell
    Found a couple links that might be helpful:
    Maybe one of them will put you on the right track.  Not a lot of folks are into Report Builder yet and this sounds like a configuration or secruity issue.  Good luck.
    LVL 2

    Accepted Solution

    Can this question be resolved as I have found the solution.

    Had to phone Microsoft in the end.

    This issue only occurs when you use SQL reporting 2008 and an SSL certificate.

    Solution is below:

    Cannot upload RDL file to SSRS using Report Builder 2.0.

    Windows 2008 SP1
    SSL is used.

    Possible Root Cause
    The default request size of 16kb is not large enough to contain the full HTTPS request before the certificate is fully processed.
    Since we try and flush the buffer but the cert is not fully negotiated the web server will tell the client to close the connection.

    Suggested Resolution
    1) Add the registry key called "MaxRequestBytes" to "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters" and set it to a value of 0n5242880 (5MB).
    NOTE! One report I found said to set the value to 0n5242880 and another report said to set the value to 5242880 (without the leadin 0n).
    You might want to try the second one as well should not the first resolve the issue.
    2) Stop the SRS Service from Reporting Services configuration manager
    3) Stop the HTTP service by typing "net stop http" from the command prompt.
    4) Start the HTTP service by typing "net start http" from the command prompt.
    5) Start the SRS service
    6) Try uploading the Report from the report manager.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
    A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now