Bromcom-PR (29th March 2014)
Our new MIS (Bromcom) has a Print Button.... When staff press print, IE asks to installed the add-on "Microsoft SQL Server" from "Microsoft Corporation"
If they click "Allow" in IE 10 it then pops up the UAC window...
I have had a good search and found this page that shows how to copy, extract and then register the DLLs.... Reporting Services Client-Side Printing and Silent Deployment of RSClientPrint.cab ActiveX file
Ive done this and it doesn't work.
It would be amazing if anyone had an MSI for this or even some knowledge on how to resolve it!!!
Thanks in advance!
Last edited by ZeroHour; 28th March 2014 at 10:54 PM.
Might be worth posting in the MIS section. Have you contacted their support desk?
I think it is a Microsoft SQL and network security problem. Bromcom use the SQL reporting add-on. But I would have thought they would have a solution.
It's a total pita. Ps financials has the same problem.. Which is in fact an microsoft issue..
Just bite the bullet and floor walk round all the users/computers that need to print reports. (And that comes from me, who refuses to install anything that can't be deployed in an automated fashion)
For BromcomMIS there are a couple of workarounds...
1) Print via the server (if you've got an on-prem installation)
2) Export to pdf and print the resultant file.
3) teach people to schedule and have reports emailed to themselves.. Or to the person who requested it.
Hoping that SQL 2012 reporting services has this one solved.
Edit: nope, 2012 has the same issue. This chap even leveraged his company's premier support contract and the solution is ugly:
But it does point to a 64/32 bit gotcha that may be the cause of your problems in repackaging it..
Last edited by psydii; 29th March 2014 at 09:25 AM.
Thanks to other forum members for their helpful input.i hope the workaround suggested by @psydii works for you for the time being.
Currently it requires UAC each and every time they print? Are you suggesting that logging in as Admin and run/install once will stop it then for staff later?
We only had to do it once... But staff tend to only work on one device and roaming user profiles persist between sessions.
Reponse from our technical sources is as below, please let us know how you get on:
RSClientPrint.msi can be downloaded via:
Or CAB files can be downloaded via for manual distribution of DLL and RLL files:
· 64-bit: http://support.bromcom.com/UploadedF...tPrint-x64.cab
· 32-bit: http://support.bromcom.com/UploadedF...tPrint-x86.cab
Instructions are below:
12 : Reporting Services Client Print Installation via CAB Files
The information in this article applies to:All
DESCRIPTIONDue to access rights on clients machines client print control cannot be installed by users. This can be done via files distribution of CAB Files.Bromcom MIS Reports are delivered using Microsoft SQL Server Reporting Services, a component of Microsoft SQL Server.Reporting Services displays reports to users in a web browser. In order to print reporting services reports to a client-connectedprinter, Reporting Services uses a small ActiveX component known as RSClientPrint. Upon first attempt to use the client printfunction (or first attempt after installing a Reporting Services update such as an SQL Server service pack), IE will prompt the userto download and install the ActiveX control.The ActiveX control may be manually pre-deployed to client machines. This is desirable:
1. To save users having to accept the ActiveX installation prompts; or
2. If Internet Explorer security settings are such that the installation of the ActiveX control would not be permitted.
3. The installation via the 'yellow bar' prompt in Internet Explorer has failed on a previous occasion.The ActiveX control files are in RSClientPrint.cab, this can be downloaded via Downloads section of Support Site.The cab file contains the following which should be copied to thec:\windows\Downloaded Program Files folder on the clientmachine:RSClientPrint_1040.rll
NOTE: Default Windows system permissions may mask the files in this directory. Copying the files into the folder via a commandline should make it clear that the files have actually been copied.gdiplus.dllrsclientprint.dllRSClientPrint_1 028.rllRSClientPrint_1031.rllRSClientPrint_1033.rl lRSClientPrint_1036.rll
RSClientPrint_1041.rllRSClientPrint_1042.rllRSClie ntPrint_1043.rllRSClientPrint_1046.rllRSClientPrin t_1049.rllRSClientPrint_1053.rllRSClientPrint_2052 .rllRSClientPrint_3082.rllOnce these files have been installed, RSClientPrint.dll needs to be registered:regsvr32.exe "C:\Windows\DownloadedProgram Files\RSClientPrint.dll"If writing a batch file to automate this process it may be necessary to force the installation and registration of files above to rununder a separate account with administrative privileges. The following batch file may be used as a guide:@echo off@Rem Skip if already installed (might not work if attempting to upgrade an older version!)if exist "c:\Windows\Downloaded Program Files\gdiplus.dll" goto endd@Rem Specify source directory (copy of files from cab file)set srcpath=\\eee-server\files@Rem Install Files%srcpath%\psexec.exe /accepteula -u administrator -p my-password cmd.exe /c xcopy %srcpath%\rsclient\* "c:\Windows\Downloaded Program Files" /y@Rem RegisterA DDITIONA LKeywordsLast Updated 29/03/2014 11:33:00
Great response... and on a Saturday
1) tried installing as admin.. it installs but normal staff still get AUC
2) Tried the MSI - Staff still get UAC
3) tried copying the files (they were already there) and then registering the DLL. The registration was a success, but still need UAC
For Monday i will tell them to export the PDF..
will test more when everything settles. Printing is quite a big requirement though
What happens if you log on as a normal member of staff, and them provide admin credentials as required? For us this resulted in the activex control installing and persisting between sessions for that user on that machine.
I.e. For every user who needs to print reports, you have to visit them and physically type your admin credentials into the uac box.
As I said a PITA. Quite how MS think this is acceptable is beyond me. (It's been an issue since sql server 2005!)
Q.What happens if you log on as a normal member of staff, and them provide admin credentials as required? For us this resulted in the activex control installing and persisting between sessions for that user on that machine
If I authenticate for then with admin credentials the print client loads and they can print. If they then try and print again.. it then again asks for authentication.
We seem to have it worse than you
There must be a solution! Will look next week when we settle. Might try giving permission to a test user to windows\* and work backwards
Last edited by burgemaster; 29th March 2014 at 07:11 PM.
Which version of SQL Server 2008 do you have installed? The latest (2008 SP3 with CU16)?
Does the version of the RSClientPrint ActiveX control in Bromcom's MSI match that of your SQL server? If not, this might be why you are still seeing the UAC popup.
Process Monitor or the Standard User Analyzer wizard in Microsoft's Application Compatibility Toolkit to find out what happens after you enter the admin credentials. The latter is usually quite good at finding out what's causing UAC popups to appear, although I have never used it with ActiveX controls before.
If you want to give it a try, I have attached a 64-bit MSI I created for v11.0.3412 of the RS Print Client (which also installs the 32-bit DLLs). However, I'm not sure if it will be compatible with Bromcom's MIS since the files are taken from SQL Server 2012 SP1 CU9.
There are currently 1 users browsing this thread. (0 members and 1 guests)