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.
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:
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
This issue occurs because the RSClientPrint ActiveX control handles the WM_INITDIALOG messages of the printing dialog box incorrectly.
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
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:
Run Internet Explorer 8, click Tools on the menu, and then click Internet Options to open the Internet Options dialog box.
In the Internet Options dialog box, click the Security tab.
On the Security tab, click the Local intranet zone, and then click to clear the Enable Protected Mode check box.
On the Security tab, click the Trusted sites zone, and then click to clear the Enable Protected Mode check box.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about how to integrate Reporting Services and SharePoint, visit the following Microsoft Developer Network (MSDN) website: