SSRS 2008 R2 client print control prompt to downloads every time I click on print button in report viewer

Question

We are running SSRS 2008 R2.  Clients are Windows 7 .

Whenever we try to print a report using the print button, it wants to download and install the client print control the first time you try to print a report in a new browser session.

That is, we open a browser, navigate to a report, click the print button, it pops up the "Internet Explorer - Security Warning" window with the "Do you want to install this software?" dialog.  Name is "SQL Server Reporting Services 2008 R2", publisher "Microsoft Corporation". 

If I click Install, it installs and then I can print.  It does not do that on subsequent reports as long as I do not close the browser.

If I close the browser, then repeat this process, I have to install the control again.

How can I get it to install so it doesn't ask every time?

---

monir

Answer 1

this is a known issue. Please refer to this link

http://support.microsoft.com/kb/2295244

Answer 2

Hi,

That fix did not work. Any other help please ? I wonder what all organization do to give facility to use that print of SSRS report ? Because all user do not have right to install anything in the organization. I have tried this link to deploy the Reporting Services Client-Side Printing and Silent Deployment of RSClientPrint.cab ActiveX file according to: http://www.kodyaz.com/articles/client-side-printing-silent-deployment-of-rsclientPrint.aspx But still I am getting the same message which is asking me to install ActiveX.

Thanks.

---

monir

Answer 3

this is a known issue. Please refer to this link

http://support.microsoft.com/kb/2295244

Hi Krishna,

It is not working for me. I did upgrade the CU3, no luck. Then tried with latest CU, still no luck.

Any help please ?

Thanks.

---

monir

Answer 4

Hello Monir,

I want to confirm with you that you installed the latest CU and SP on the report server, and restart the machine to apply the changes. If the machine is not restarted, please try to restart it to see whether it can solve your issue.

In addition, since the client is Windows 7, I doubt that the UAC may interfere our troubleshooting. Can you turn off the UAC or run the browser in "Run as Administrator" mode?

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 5

Hello Monir,

I want to confirm with you that you installed the latest CU and SP on the report server, and restart the machine to apply the changes. If the machine is not restarted, please try to restart it to see whether it can solve your issue.

In addition, since the client is Windows 7, I doubt that the UAC may interfere our troubleshooting. Can you turn off the UAC or run the browser in "Run as Administrator" mode?

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Hi Edward,

Thank you for your email. I did restart the report server after upgrade as the upgrade was asking for restart. Now normal user do not have permission to run any application as administrator. So when I tried to run as administrator, it is asking for userid and pass. And if I turn off the UAC in the Win 7 Client PC, I got error message, unable to print. I was trying all the options last week. But now bit frustrating. Can you please tell me what CU update exactly should work ? I tried CU3 and it did not work. I tried latest CU which I think was CU 7 or 8 cant remember now and no luck. 

Many thanks.

---

monir

Answer 6

Hello Monir,

Thanks for your response.

The CU3 can solve part of issues, like your description, since it just fixed the problem that the RSPrintControl does not have the same version with the reporting service. Remember that if this is the first time to launch print control after you install the CU, the browser may require you download the print control to upgrade the installed version. If you install the latest CU, we can exclude this possibility and return the start to find out the other possibilities.

For this scenario, my suggestion is to install the RSPrintControl manually on the client side. We have a document on MSDN blog to describe this kind of problem. I suppose you can install it as following step.

1. Find out the RSPrintControl on the server side. The default location is: C:\Program Files\Microsoft SQL Server\MSRS10_50.<instance name>\Reporting Services\ReportServer\bin\RSClientPrint.cab.
2. Copy the file to the client side and extract the cab file to the folder, e.g. C:\print.
3. Run the command line tool under "Run as administrator", and run the command
   

   c:\print>regsvr32 rsclientprint.dll

Then, please check whether the issue is gone. For more information, please refer to the next article.

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

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 7

Hello Monir,

Thanks for your response.

The CU3 can solve part of issues, like your description, since it just fixed the problem that the RSPrintControl does not have the same version with the reporting service. Remember that if this is the first time to launch print control after you install the CU, the browser may require you download the print control to upgrade the installed version. If you install the latest CU, we can exclude this possibility and return the start to find out the other possibilities.

For this scenario, my suggestion is to install the RSPrintControl manually on the client side. We have a document on MSDN blog to describe this kind of problem. I suppose you can install it as following step.

1. Find out the RSPrintControl on the server side. The default location is: C:\Program Files\Microsoft SQL Server\MSRS10_50.<instance name>\Reporting Services\ReportServer\bin\RSClientPrint.cab.
2. Copy the file to the client side and extract the cab file to the folder, e.g. C:\print.
3. Run the command line tool under "Run as administrator", and run the command
   

   c:\print>regsvr32 rsclientprint.dll

Then, please check whether the issue is gone. For more information, please refer to the next article.

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

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Hi Edward,

Thanks for your reply. I went through the blog before I put my problem in this forum. The blog was created mainly for Microsoft SQL Server 2005 and report viewer 8.00.50727 and 9.00.XXXX. Our version is SQL Server 2008 R2 and report viewer 10.xxxx. I deploy the control manually as described at the bottom of the blog. I got the message, it registered succeed. But then I am getting this download message every single time I try to print a report. And normal user DO NOT have right to run as administrator and download files. Do you know anyone who had same environment we do and they can print ? Like this site http://www.reportsurfer.com/Default.aspx?PageID=1164658&A=WebApp&CCID=2897&Page=4&Items=8 I am getting same unable to print error from any client PC here for normal user login.

---

monir

Answer 8

Hello Monir,

Is the account, by which you want to print the report, a administrator or power user on the client machine? It is very important for Windows Vista and later Windows OS, since new security mechanism is used on these system. Only the account having the power user or administrator permission can install and launch the ActiveX control the client machine. If the account is only normal user on the client side, the report cannot be printed definitely.

We have some threads to discuss that the normal user cannot download and run ActiveX control in the browser. Here are some of them.

http://social.technet.microsoft.com/Forums/en/w7itprosecurity/thread/9be73b8c-8847-4aff-8da7-17e938caee8d
http://technet.microsoft.com/en-us/library/cc721964(v=ws.10).aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/477ccb70-db73-4494-8454-2f932e83c433

I hope it can be helpful to you.

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Answer 9

I set up both settings in the following link (the Win7 version of the middle link above) which worked (might not actually have had to do both...) http://technet.microsoft.com/en-us/library/dd631688%28v=ws.10%29

Answer 10

Hello Monir,

Is the account, by which you want to print the report, a administrator or power user on the client machine? It is very important for Windows Vista and later Windows OS, since new security mechanism is used on these system. Only the account having the power user or administrator permission can install and launch the ActiveX control the client machine. If the account is only normal user on the client side, the report cannot be printed definitely.

We have some threads to discuss that the normal user cannot download and run ActiveX control in the browser. Here are some of them.

http://social.technet.microsoft.com/Forums/en/w7itprosecurity/thread/9be73b8c-8847-4aff-8da7-17e938caee8d
http://technet.microsoft.com/en-us/library/cc721964(v=ws.10).aspx
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/477ccb70-db73-4494-8454-2f932e83c433

I hope it can be helpful to you.

Regards,

Edward

---

Edward Zhu

TechNet Community Support

Normal user are not a administrator or power user on the client machine? And they supposed not to be coz of security reason. I am going to try Yohn222 link to see if I can work it out. But this thing is driving me crazy now :( Thanks for your links.

---

monir

Answer 11

Hello Monir,

How are you?

I am writing in to see whether Yohn22 link works on your side. If you have further questions about this post, please tell us freely.

Thanks,

Edward

---

Edward Zhu

TechNet Community Support

Answer 12

Hello Monir,

How are you?

I am writing in to see whether Yohn22 link works on your side. If you have further questions about this post, please tell us freely.

Thanks,

Edward

---

Edward Zhu

TechNet Community Support

Hi Edward,

Sorry for late reply. I tried Yohn22 link but still no luck. Its still asking for Administrator User id and password :(

---

monir