[bromcom] SQL Server Reporting Services 2008 - Requires UAC !!!! please help

[burgemaster]

Hi,

 

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!

 

Edited March 28, 2014 by ZeroHour

[matt40k]

Might be worth posting in the MIS section. Have you contacted their support desk?

[burgemaster]

Thanks Matt.

 

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.

[psydii]

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:

http://www.sqlslayer.com/wp/2013/09/20/upgrading-to-ssrs-2012-client-side-printing-silent-deployment-of-rsclientprint-aspx/

 

But it does point to a 64/32 bit gotcha that may be the cause of your problems in repackaging it..

Edited March 29, 2014 by psydii

[Bromcom-PR]

Hi,

 

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!

 

[ATTACH=CONFIG]23612[/ATTACH]

[ATTACH=CONFIG]23613[/ATTACH]

[ATTACH=CONFIG]23614[/ATTACH]

 

Please contact our Helpdesk Monday morning for assistance. We will also post any relevant information in this thread as well.

 

Thanks to other forum members for their helpful input.i hope the workaround suggested by @psydii works for you for the time being.

[burgemaster]

Thanks..

 

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?

[psydii]

We only had to do it once... But staff tend to only work on one device and roaming user profiles persist between sessions.

[Bromcom-PR]

Hi,

 

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!

 

[ATTACH=CONFIG]23612[/ATTACH]

[ATTACH=CONFIG]23613[/ATTACH]

[ATTACH=CONFIG]23614[/ATTACH]

 

 

Hi @burgemaster,

 

Reponse from our technical sources is as below, please let us know how you get on:

 

RSClientPrint.msi can be downloaded via:

http://support.bromcom.com/UploadedFiles/RSClientPrint.msi

 

Or CAB files can be downloaded via for manual distribution of DLL and RLL files:

· 64-bit: http://support.bromcom.com/UploadedFiles/RSClientPrint-x64.cab

· 32-bit: http://support.bromcom.com/UploadedFiles/RSClientPrint-x86.cab

 

Instructions are below:

12 : Reporting Services Client Print Installation via CAB Files

The information in this article applies to:

All

DESCRIPTION

Due 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 the

c:\windows\Downloaded Program Files folder on the clientmachine:

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_1028.rllRSClientPrint_1031.rllRSClientPrint_1033.rllRSClientPrint_1036.rll

RSClientPrint_1040.rll

RSClientPrint_1041.rllRSClientPrint_1042.rllRSClientPrint_1043.rllRSClientPrint_1046.rllRSClientPrint_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 Register

A DDITIONA L

Keywords

Last Updated 29/03/2014 11:33:00

[burgemaster]

Great response... and on a Saturday

Thank you.

[burgemaster]

No good

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

[psydii]

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!)

[burgemaster]

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

Edited March 29, 2014 by burgemaster

[Arthur]

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.

[burgemaster]

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.

 

They are cloud based for us Arthur, so they have the server their end. They sent me the .Cab files from their server previously and they created the MSI. What is the UAC actually stopping? Will this be logged?

[Arthur]

What is the UAC actually stopping? Will this be logged?

You could try 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.

RSClientPrint v11.0.3412 (x64).7z

[burgemaster]

Arthur.... You have sorted it !!

 

Tested with a manual install on one PC. I will test on a fresh machine that I havent been messing with but looking good!

 

Thankyou so much for this!!

[Arthur]

That's excellent news! Glad to hear it worked.

 

I'm actually quite surprised since I haven't done anything particularly unique with my MSI.

 

If anyone is interested, I can also post the .wxs file I made to create the MSI (using the WiX Toolset)?

[burgemaster]

Thanks again.

one small problem remains, I now need "Initialize and script ActiveX controls not marked as safe for scripting" enabled in the security settings in IE. Will look at sorting this in GPP.

Also could I please have the WIX before I deploy blindly to all our computer. (not that I don't trust you completely)

[Arthur]

Also could I please have the WIX before I deploy blindly to all our computer.

Sure. No problem. I've attached it below.

 

The code should be pretty self-explanatory, but if you have any questions just ask.

RSClientPrint v11.0.3412 (WiX).7z

[burgemaster]

With the "Initialize and script ActiveX controls not marked as safe for scripting" marked as enabled. Users then got a lovely new homepage telling them their settings were unsafe..

So I added "cloud.bromcom.com" in to the trusted site list.

 

Computer Configuration | Administrative Templates | Windows Components | Internet Explorer | Internet Control Panel | Security Page

 

And then made the ActiveX scripting change in the trusted site settings with GPP.

 

Seems to be all working... Should be good to go for launch Monday!

Thanks for the help

[psydii]

Good luck with launch day!

[Bromcom-PR]

With the "Initialize and script ActiveX controls not marked as safe for scripting" marked as enabled. Users then got a lovely new homepage telling them their settings were unsafe..

So I added "cloud.bromcom.com" in to the trusted site list.

 

Computer Configuration | Administrative Templates | Windows Components | Internet Explorer | Internet Control Panel | Security Page

 

And then made the ActiveX scripting change in the trusted site settings with GPP.

 

Seems to be all working... Should be good to go for launch Monday!

Thanks for the help

 

Please maintain contact with our Helpdesk with any further assistance you may need and good luck with your launch today.

 

Many thanks to @burgermaster for the help provided over the weekend.