Under IE7, on Windows XP SP3, without administrative rights (i.e. user not in local administrators group), a request to print a report from SQL Server 2008 R2 Reporting Services running on Windows Server 2003 R2 or WIndows Server 2008 returns the error message: "unable to load client print control.". The problem is not present if the user has administrative rights. The problem is present even after applying SQL Server 2008 R2 CU6 when user does not have administrative rights. We need this printing to work even if the user doesn't have administrative rights as the majority of our users run without administrative rights. Can anyone please help? I believe the problem is the install of the client print control is not done under elevated priviliges.

Hi Ivan Piacun, The ReportViewer control provides an ActiveX print control for reports. Actually, downloading and installing the ActiveX control RSClientPrint.cab requires administrator permissions on the client machine, without administrator permissions, there will be this error message "Unable to load client print control". If the users weren’t administrators, the issue could be resolved by deploying the files manually, steps are: 1. Go to C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin on the report server and copy the rsclientprint.cab file 2. Extract the files from the rsclientprint.cab file. 3. Copy all the files to the client computer to Windows\Downloaded Program Files (you might need to do it using the command windows) c:\print\RSClientPrint.dll c:\print\rsclientprint.inf c:\print\RsClientPrint_1028.rl c:\print\RsClientPrint_1031.rl c:\print\RsClientPrint_1033.rl c:\print\RsClientPrint_1036.rl c:\print\RsClientPrint_1040.rl c:\print\RsClientPrint_1041.rl c:\print\RsClientPrint_1042.rl c:\print\RsClientPrint_2052.rl c:\print\RsClientPrint_3082.rl 4. Register RSClientPrint.dll by opening a command line (Start->Run) regsvr32 [path]RSClientPrint.dll You can also create a script to install the control using “Run As”, for detail steps please see: http://blogs.msdn.com/b/mariae/archive/2010/04/13/error-unable-to-load-client-print-control-when-printing-reports-in-reporting-services-summary-of-all-possible-causes-at-april-2010.aspx Besides, I still recommend you to configure Internet Explorer to allow ActiveX control downloads, follow these steps: 1. In Microsoft Internet Explorer, from the Tools menu, choose Internet Options, and then click the Security tab. 2. Click the Custom Level button. Scroll to the ActiveX controls and plug-ins node. 3. Click Enable for Download signed ActiveX controls, and then click OK. Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Challen If we deploy the SSRS 2008 R2 Client Print Control manually does this mean when there is a new version due to a service pack we need to unregister the old version of the dll and delete the files before installing the new version which we would have to deploy manually again. Is there no install file for this from MicroSoft which we can deplay which will uninstall the old version if present? I guess the need to set up an install file manually may be necessary because we are running Wndows XP clients and IE7. Is that the case please? Kind Regards Ivan Piacun ____________________________ Regards Ivan Piacun MNZCS Senior Developer and Database Administrator AgResearch Limited

Hi Ivan, By generally, there is a install file to install when you click the install button on ReportViewer control, but downloading and installing the ActiveX control RSClientPrint.cab requires administrator permissions on the client machine, this is be default, here you mentioned, you user has no administrator permissions, so my reply is just a workaround for you. If your user has administrator permissions, there is no problem for your top issue. Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hello Challen, I tried what you suggested. I copied the files into c:\windows\downloaded program files and ran regsvr32 from the cmd prompt. Non-admin logins still get the "Unable to load client print control" error, even after loosening restrictions on ActiveX in IE. See: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b5f3be76-058e-4531-9194-be2c6c7a3a81 Thanks.Alton