sqlshots: Reporting Services 2005 - Unable to load client print control
I received a trouble support call from a client that encountered an error while attempting to print a Report via Reporting Services. The client was able to print before then suddenly it became an issue. Coincidentally Microsoft released two hotfixes (KB956803 & KB956391) which added a “kill-bit” associated to the ActiveX printing control used by Reporting Services 2005.
Hotfix KB956803 only affects Windows XP & Windows 2003 platforms while Windows 2000, Vista and 2008 platforms were not affected. Hotfix KB956391 seems intended to patch vulnerabilities within the Office products.
There are a few ways to go about it and correct it:
Possible Solutions on the (Client Side)
1) Uninstall both hotfixes (KB956803 & KB956391)
2) Install the following Reporting Services update (http://www.microsoft.com/downloads/details.aspx?FamilyID=82833f27-081d-4b72-83ef-2836360a904d&DisplayLang=en)
3) Delete a single key in the registry (Which is what I chose)
Corrective Steps for item 3
a) I located and deleted the following key from the registry. [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{FA91DF8D-53AB-455D-AB20-F2F023E498D3}]
b) Then I had restarted (close/re-launched) all IE sessions
c) Browsed to the Reporting Services url
d) Opened a report
e) Clicked the print button (if you have or haven’t installed the print client you may or may not receive the yellow “Install ActiveX” dialog just below the IE header area. You may just receive the Print Dialog instead.)
f) The report printed fine
Comments [0]