none
The underlying connection was closed: An unexpected error occurred on a send. RRS feed

  • 問題

  • Hi all,

     

    I have encountered this error when I tried to deploy reports to another SQL2008 runnig reporting service. I can run the reports in my development machine (Windows 2008 + SQLServer 2008 evaluaton copy)

     

    I encountered the same error when I tried to access http://myserver/reports/

     

    My SQL2008 runs on a Windows Server 2008 Standard with SharePoint Service 3.0.

     

    My installation doesn't use SharePoint integration mode

     

    See anyone has idea about this.

     

    Thanks in advance.

     

    Terran

     

    2008年12月15日 上午 06:16

解答

所有回覆

  • What's the error?

     

    2008年12月15日 下午 05:19
  • Have you enabled SSL for your Reporting Services?

     

    2008年12月15日 下午 09:35
  • I think I haven't as I don't know where to enable.

     

    However I finally found a thread in a forum which suggested to modify the rsReportServer.config by changing the value of SecureConnectionLevel from 2 to 0. I had tried and the error is gone.

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/31196bf7-1c8b-47b1-87a0-7cb117df97bd/

     

    And this setting seems related to SSL.

     

    See anyone can provide more information on this.

    2008年12月17日 上午 12:43
  • The error is "The underlying connection was closed: An unexpected error occurred on a send."

     

    It was shown in IE when I visited the http://myserver/reports or in VS2008 when I deployed the reports.

     

     

     

    2008年12月17日 上午 12:47
  • Then did you try connect without SSL?

    2008年12月17日 下午 03:24
  • I haven't used SSL at all.

     

    2008年12月18日 上午 01:36
  • This is absolutely correct. Setting value from 2 to 0 solved the problem. And I can deploy and see my report in browser.
    (I am using Business Intelligent Development Studio) for this.

     

    Many thanks to terrank. ( rsReportServer.config by changing the value of SecureConnectionLevel from 2 to 0.)

    - Soumen - India

    2008年12月29日 上午 06:19
  •  terranc wrote:

    I think I haven't as I don't know where to enable.

     

    However I finally found a thread in a forum which suggested to modify the rsReportServer.config by changing the value of SecureConnectionLevel from 2 to 0. I had tried and the error is gone.

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/31196bf7-1c8b-47b1-87a0-7cb117df97bd/

     

    And this setting seems related to SSL.

     

    See anyone can provide more information on this.

     

    Hello

     

    Yes, this change is related to SSL -- also, this solution worked for me too.  I do not know why this flag was incorrectly set by Report Server.  My problem was using SSAS 2008 on Vista.

     

    I will provide a link on how to change rsReportServer.config:

    http://msdn.microsoft.com/en-us/library/bb630448.aspx

     

    Also, my specific copy of this config file was in the following directory (different from the MSDN documentation):

    \Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer

     

    To contrast, the MSDN documentation said:

    "RSReportServer.config is located in the \Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer folder."

     

    Finally, I made copy first of rsReportServer.config, and then I changed the original file.  It is always important to make copies of configuration files before changing them (in case you need to go back).  Once I saved and closed the file, I was able to successfully deploy.  I did not stop any services to do this editing (though you may have to if you have other users actively using Reporting Services on that server).

     

     

    2009年1月16日 上午 05:24
  • hi,

    changing the value from 2 to 0 in the
    rsReportServer.config file works for me only whe I deploy my report using BI development studio, but when I try to see my report using my browser i get the next error:

    An error occurred during client rendering.
                    Execution '03p2ej45ojayvy45ivcltjfl' cannot be found

    do you have any idea about this?

    thanks
    2009年1月21日 下午 08:50