There is no policy that we have configured to do this. Other sites that active x work fine as far as I know. I will try to test this some more and post back on this. Thanks for the suggestion Chrismc
Main Topics
Browse All TopicsHi,
We run a SQL Server 2005 server with Reporting Services enabled, both running on the same machine; Windows Server 2003 Standard R2 x64. We keep running into the "unable to load client print control" error when users try to print reports from our terminal servers. I was able to solve the issue for our users that run locally on their computers but not for the users who run off of the terminal servers. To solve the issue for the local users, all i did was installed the update for SQL server and then the end users were able to open and print their reports. This however didn't solve the issue on the terminal servers.
Our terminal servers are Windows 2003 Standard x86 and Windows 2003 Standard R2 x64 with all of the latest updates as of the 15th installed on them.
In my testing, any user who has administrative rights on the terminal servers can run and print reports without getting the "unable to load client print control" error message. If it is the first time a user has tried to print a report it asks if they want to install the ActiveX, which they click install to, and then it works. I have tried adding a user to have administrative rights and go in and get this installed under their profile and then remove the administrative rights, but as soon as they try printing again it fails with the unable to error.
I have also tried to manually install the RSClientPrint from the cab file that the reporting server has and it installs successfully but still doesn't allow a user to print the reports.
Has anyone been able to get this to work on a terminal server or have any ideas?
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I have checked and we do not have a policy in place that blocks ActiveX controls from being installed on the terminal servers. In my searching though, I did find that in order to install an ActiveX control a user must have administrative rights on the machine where they wish to install it, in this case our Terminal Servers, but we can't give our users administrative permissions.
I did find this site (http://www.vinsvision.com
layfieldgroup.
I've been through this a number of times, and the two ways we came up with to get around this is
1. Install on the terminal server as an administrative user, copy the profile for that user into the Default User dir all new accounts will be created w/ access to that activeX
2. You can manually copy the rsPrintClient.dll onto the server and regsrv32 the DLL
3. Create an MSI package and deploy via GPO http://bogdanbrinzarea.wor
Thank you for the response Auric1983,
For number 1 what all do you copy over as I am unsure. Everything in the profile directory?
For number 2, i have tried registering it which it says is successful. I then log on as a normal user and try to go to our reporting services site to print the report. It pops up asking to install the control, which when i press install it then comes up with the "unable to load client print control" error message.
For number 3, I get the same behaviour as for number 2.
I tried with creating a brand new user and then logging onto the server and it works for that user but not for any existing users. Any pointers on how to fix that one, since I really don't want to field calls from all of our users (150+) to recreate their profiles.
Thanks
there maybe a file lurking in the existing users setup that is not getting overwritten.
I'm not sure what exactly it downloads but if you can work that out and clear it out for the existing users, it may resolve your problem.
This link goes into some detail on what gets installed;
http://www.kodyaz.com/arti
Cheer
Chris
Thank you Auric. I found the part about the update that brakes SSRS printing, and I have applied the updates to our Reporting Server that corrected that portion of the issue. Before those updates it didn't work on any of our clients and once that was installed the local clients were able to print. Now it is just a matter of getting it to work on the terminal servers.
I am in the process of deleting a profile for an existing user and then I will let it recreate and see if it works or not. If this works, I think deleting them and recreating them will be the way to get it working. Maybe I can back up their current profiles and then write a script that copies back the few things that they need out of them.
Deleting an existing users profile and letting it get recreated did the trick. What a pain.
Too bad I can't find what is causing the issue. I have tried deleting everything to do with Internet Explorer from the profile but that didn't help. I guess I will need to start deleting profiles for people who need to print from SSRS.
[QUOTE Auric1983]
I've been through this a number of times, and the two ways we came up with to get around this is
1. Install on the terminal server as an administrative user, copy the profile for that user into the Default User dir all new accounts will be created w/ access to that activeX
2. You can manually copy the rsPrintClient.dll onto the server and regsrv32 the DLL
3. Create an MSI package and deploy via GPO http://bogdanbrinzarea.wor
[/QUOTE]
For Auric's number 2&3 this worked for any new user that had logged on but not for already existing users. Since this isn't an issue on our dektops and only on our Terminal Servers I have opted to go with option 2 as what I am going to put in place to solve this issue and then delete the profiles of any users who need it that already exist and recreate their profile.
That's the one unfortunate piece that I haven't been able to figure out either.
In our case because all of our users are restricted via GPO on the terminal server they don't really have access to anything other than the Application we want them working in, so recreating a profile wasn't a big deal. Just had to remind users to double check their default printer.
Ya, thats pretty much the same case for us too, but our users who use the terminal servers do everything on them. So they need their favorites backed up, the outlook NK2 email address cache file, and some other things as well.
Thank you for you help in finding a solution that will get us able to print from SSRS Auric.
Business Accounts
Answer for Membership
by: chrismcPosted on 2009-08-24 at 21:13:38ID: 25174507
This is a wild shot in the dark but is there some policy in place against the terminal server to prevent it running ActiveX?