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?