+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 22
MIS Systems Thread, SQL Server Reporting Services 2008 - Requires UAC !!!! please help in Technical; Hi, Our new MIS (Bromcom) has a Print Button.... When staff press print, IE asks to installed the add-on "Microsoft ...
  1. #1

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27

    SQL Server Reporting Services 2008 - Requires UAC !!!! please help

    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!

    UAC.png
    SQL ADdin.png
    unable.png
    Last edited by ZeroHour; 28th March 2014 at 11:54 PM.

  2. Thanks to burgemaster from:

    Bromcom-PR (29th March 2014)

  3. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,489
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    Might be worth posting in the MIS section. Have you contacted their support desk?

  4. Thanks to matt40k from:

    Bromcom-PR (29th March 2014)

  5. #3

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    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.

  6. Thanks to burgemaster from:

    Bromcom-PR (29th March 2014)

  7. #4

    Join Date
    Jul 2006
    Location
    London
    Posts
    1,273
    Thank Post
    114
    Thanked 244 Times in 195 Posts
    Blog Entries
    1
    Rep Power
    75

    SQL Server Reporting Services 2008 - Requires UAC !!!! please help

    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/...entprint-aspx/

    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 10:25 AM.

  8. 3 Thanks to psydii:

    Bromcom-PR (29th March 2014), burgemaster (29th March 2014), JohnCondon (24th April 2014)

  9. #5

    Join Date
    Dec 2013
    Location
    Bromley
    Posts
    60
    Thank Post
    15
    Thanked 7 Times in 6 Posts
    Rep Power
    3
    Quote Originally Posted by burgemaster View Post
    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!

    UAC.png
    SQL ADdin.png
    unable.png
    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.

  10. #6

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    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?

  11. #7

    Join Date
    Jul 2006
    Location
    London
    Posts
    1,273
    Thank Post
    114
    Thanked 244 Times in 195 Posts
    Blog Entries
    1
    Rep Power
    75
    We only had to do it once... But staff tend to only work on one device and roaming user profiles persist between sessions.

  12. #8

    Join Date
    Dec 2013
    Location
    Bromley
    Posts
    60
    Thank Post
    15
    Thanked 7 Times in 6 Posts
    Rep Power
    3
    Quote Originally Posted by burgemaster View Post
    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!

    UAC.png
    SQL ADdin.png
    unable.png

    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/UploadedF...lientPrint.msi

    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

    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_1 028.rllRSClientPrint_1031.rllRSClientPrint_1033.rl lRSClientPrint_1036.rll
    RSClientPrint_1040.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 Register
    A DDITIONA L
    Keywords
    Last Updated 29/03/2014 11:33:00

  13. 2 Thanks to Bromcom-PR:

    burgemaster (29th March 2014), psydii (29th March 2014)

  14. #9

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    Great response... and on a Saturday
    Thank you.

  15. #10

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    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

  16. #11

    Join Date
    Jul 2006
    Location
    London
    Posts
    1,273
    Thank Post
    114
    Thanked 244 Times in 195 Posts
    Blog Entries
    1
    Rep Power
    75
    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!)

  17. #12

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    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 08:11 PM.

  18. #13


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    9,653
    Thank Post
    253
    Thanked 2,918 Times in 2,149 Posts
    Rep Power
    831
    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.

  19. Thanks to Arthur from:

    burgemaster (29th March 2014)

  20. #14

    Join Date
    Aug 2007
    Posts
    848
    Thank Post
    106
    Thanked 66 Times in 47 Posts
    Rep Power
    27
    Quote Originally Posted by Arthur View Post
    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?

  21. #15


    Join Date
    Feb 2007
    Location
    51.403651, -0.515458
    Posts
    9,653
    Thank Post
    253
    Thanked 2,918 Times in 2,149 Posts
    Rep Power
    831
    Quote Originally Posted by burgemaster View Post
    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.
    Attached Files Attached Files

  22. Thanks to Arthur from:

    burgemaster (29th March 2014)



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 2
    Last Post: 15th July 2011, 10:12 AM
  2. [SIMS] SIMS.Net / SQL Server 2008 Service Pack 2 (SP2)
    By Minkus in forum MIS Systems
    Replies: 5
    Last Post: 13th December 2010, 03:34 PM
  3. Server 2003 - Blue Screen of Death - please help!
    By sharkster in forum Windows Server 2000/2003
    Replies: 23
    Last Post: 1st October 2009, 10:36 AM
  4. Moving from SQL Server 2005 to 2008
    By speckytecky in forum MIS Systems
    Replies: 19
    Last Post: 9th July 2009, 04:34 PM
  5. SQL Server 2008 Maintenance course
    By googlemad in forum Courses and Training
    Replies: 0
    Last Post: 25th January 2009, 11:12 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •