FIX: "An error occurred during this operation" error when you try to print a report from a SharePoint Server 2010 website in Internet Explorer 8

Article translations Article translations
Article ID: 2445751 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.

Important This article contains information that shows you how to help lower security settings or how to turn off security features on a computer. You can make these changes to work around a specific problem. Before you make these changes, we recommend that you evaluate the risks that are associated with implementing this workaround in your particular environment. If you implement this workaround, take any appropriate additional steps to help protect your computer.
Expand all | Collapse all

On This Page

Symptoms

Consider the following scenario:
  • You have a computer that is running Windows Vista or a later version of Windows. The User Account Control (UAC) feature is enabled in Windows.
  • You click to select the Enable Protected Mode check box for the following zones in the Windows Internet Explorer 8 security settings:
    • Internet zone
    • Local intranet
    • Trusted sites
  • You install the Microsoft SQL Server 2008 R2 Reporting Services add-in on a Microsoft SharePoint Server 2010 server.
  • You run the SharePoint 2010 server in either the Local mode or in the Connected mode.
  • You publish a report on the SharePoint website. For example, you publish a Microsoft Access 2010 web database that contains a web report to the SharePoint website.
  • You install the RSClientPrint ActiveX control in Internet Explorer 8 to enable report printing.
  • You access the SharePoint website by using Internet Explorer 8 and try to print the report.

In this scenario, you receive the following error message:
An error occurred during this operation

Cause

This issue occurs because the RSClientPrint ActiveX control handles the WM_INITDIALOG messages of the printing dialog box incorrectly.

Resolution

Cumulative update information

SQL Server 2008 R2

The fix for this issue was first released in Cumulative Update 5. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
2438347 Cumulative Update package 5 for SQL Server 2008 R2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

Workaround

Warning This workaround may make a computer or a network more vulnerable to attack by malicious users or by malicious software such as viruses. We do not recommend this workaround but are providing this information so that you can implement this workaround at your own discretion. Use this workaround at your own risk.

To work around this issue, disable the protected mode for the Local intranet zone and for the Trusted sites zone in Internet Explorer 8. To do this, follow these steps:
  1. Run Internet Explorer 8, click Tools on the menu, and then click Internet Options to open the Internet Options dialog box.
  2. In the Internet Options dialog box, click the Security tab.
  3. On the Security tab, click the Local intranet zone, and then click to clear the Enable Protected Mode check box.
  4. On the Security tab, click the Trusted sites zone, and then click to clear the Enable Protected Mode check box.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

For more information about how to integrate Reporting Services and SharePoint, visit the following Microsoft Developer Network (MSDN) website:
General information how to integrate Reporting Services and SharePoint

For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems
For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:
822499 New naming schema for Microsoft SQL Server software update packages
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 2445751 - Last Review: February 2, 2013 - Revision: 2.1
Applies to
  • Microsoft SQL Server 2008 R2 Reporting Services
  • Access Services in Microsoft SharePoint Server 2010
  • Microsoft SharePoint Foundation 2010
  • Microsoft SharePoint Server 2010
Keywords: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced KB2445751

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com