Hi all,We are coming across an intermittent problem when executing reports from Report Builder 2.0 in SSRS 2008. We generally try to use Report Builder 2.0 to design and deploy reports since this is the mechanism that our users use for designing and deploying reports themselves (i.e we dont want to use Visual Studio 2008). This involves designing the report in Report Builder 2.0, runing it (via report Builder), going back to design to make further changes and so on.We've had a history of configuration issues with SSRS 2008 but have steadliy overcome each problem once by one. After solving all previous issues - we are now hitting this latest issue but are at a loss of what to try next.Intermittently we are getting the following error from Report Builder 2.0: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.You can have a report open in report builder and it will run fine. You then make a change and try to run it again and you will get this error - sometimes once, sometimes two or three times, and then the next time it will work again. The major problem with this is that when the error happens, prior to seeing the error message above, Report Builder freezes for around 1 minute. This means that you have to go into finger twiddling mode until it comes back again. It's also making report development very annoying. Things to point out: We are using a remote reporting server.We ONLY use SSL to connect to the server - disabling this long term is not an option.SecureConnectionLevel is set to 3.We have following authentication types set up: RSWindowsBasic, RSWindowsNTLM.We connect to Report Server using Windows users defined on the report server machine.Server has SQL2008 SP1 installed and also CU4 I think and a single hotfix to work around previous problems.Reporting Services and the SQL Database containing report data sit on the same remote server.SQL Server Build Version is 10.0.2734.0.This happens for various reports from the simplest report to the most complex.We are using a report model for the data source within each report.I have checked the HTTP log on the SSRS server and do not see anything relating to a failure of this report. What I do see is that every successful request (status = 200)to the server is prceeded by two identical requests that get status 401.I've checked the ReportServerService log and there appear to be no entries in there relating to the requests that fail.There are no relevant entries in system Event logs.That covers everything I can think of at the moment.Does anyone have any suggestions on how to solve this or how to troubleshoot further?I suspect that it is either a network and/or SSL issue but am not sure where to go from here.Thanks

Hi Barakuda1, The error message "Unable to write data to the transport connection: An established connection was aborted by the software in your host machine." indicate the issue is related to network connectivity. Base on our experience, the root cause is 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. To solve the issue, please follow these steps: 1) Added the registry key called "MaxRequestBytes" to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters and set it to a value of 5242880 (5MB). 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 For more information, please see “MaxRequestBytes” in the follow article: http://support.microsoft.com/kb/820129 Please feel free to ask, if you have any more questions. Thanks, Jin ChenJin Chen - MSFT

I have a similar problem with the exact same error message:"System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to write data to the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine at ..."In my case I have 2 SSRS reports, one is about 100k and the other is about 257k. The smaller one deploys fine from VS and Report Manager in IE, but the larger one will not deploy from either. It worked once after several retries, but has not worked at all since then.According to the link above to "Http.sys registry settings for IIS" the "MaxRequestBytes" value should be added as a DWORD value, not a new key, to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\HTTP\Parameters. I tried this with a value of 2097152 and still have the same error message.

Hey Tim/Barakuda1, Have you guys managed to resolve this issue. We are having the same problem and have tried the action proposed by Jin, but we are still encountering the same error. We are trying to launch a clickonce Report Builder 2.0 application remotely over HTTPS. The data repository is SQL Server 2008. Can this be done? I will be greatful for any help. Thanks SQL Intermediate

I'm currently getting the same error when I try to save a report to the report server via Report Builder (2.0) and for me it is down to temporarily reduced bandwidth due to a network fault... Not sure that helps much but thought i'd post just in case. P