Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345»»

RS SP2 install RSCLIENTPrint via cab file, is there an MSI? Expand / Collapse
Author
Message
Posted Friday, July 31, 2009 7:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:20 PM
Points: 2,897, Visits: 5,979


Here is my version: 2005.90.3042.0

I will try and see if i can create a custom MSI. I don't really have the necessary files to do so. If anyone wants I can send you the CAB file and can you create the MSI for me?

Hrmm, well I confirmed with the other computer and its not working as well. Its not so much a big deal for me, that it worked over a year ago, and just recently it stopped, and the only way to print is to export to PDF. I just rather prefer to click on Print Icon.


How often do these folks patch their machines? As I mentioned before, MS published the older version of the RSClientPRint.dll on one of the activex KillBits lists. This was because it contained a vulnerable implementation of GDIPlus. You can read more about it here http://blogs.msdn.com/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx



All active X controls are enabled, AV is shut off.

IE browser is whatever came on the computer, i think its 6.0 something, i never updated. Not really an IE fan. Then again, this whole report viewer thing doesn't even work in FireFox.


It it more than likely the fact that your activeX control is listed on the killbits list so IE won't even try to load it no matter what settings within IE you have set.

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #763092
Posted Friday, July 31, 2009 7:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:20 PM
Points: 2,897, Visits: 5,979
And just to be clear... you stated you are using Build 09.00.3042 which is SQL server 2005 SP2, which was released back in 2007. This issue began with the GDIplus vuln in 2008. You server is sending out the one that IE will not even try to load.

You need to update both your client machines and the viewer control on the server. The easiest way to do this would be to install SP3 and keep your server current, which also includes patches for the sp_replwritetovarbin vulnerability discussed here http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx. A much more difficult way is to do it via the MS rsclientPrint reditributable which can be downloaded from MS.

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #763101
Posted Friday, July 31, 2009 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 25, 2009 6:53 PM
Points: 9, Visits: 10
So your telling me that once the IE client loads the Killbits list it wont try to load the activex control since im using an older version which is already blacklisted from IE?

Makes sense since im sure most of the users updated IE. And since we didnt update browser it would block it.

\And what is this kill bits? Is it a physical list that computer blocks?
Post #763204
Posted Friday, July 31, 2009 9:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 25, 2009 6:53 PM
Points: 9, Visits: 10
Found the kill bits list through the registry and was able to locate the CLSID, which is:

FA91DF8D-53AB-455D-AB20-F2F023E498D3

Dont know what good that would do me though.
Post #763211
Posted Friday, July 31, 2009 10:40 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 13, 2011 11:54 AM
Points: 19, Visits: 49
As a temporary fix, you could help the user to know how to print it to PDF and then to print the report from the PDF file?
Post #763255
Posted Friday, July 31, 2009 10:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 13, 2011 11:54 AM
Points: 19, Visits: 49
Wonder what would happen if you delete that CLSID from the Registry?

Does IE8 perform this way on that computer?
Post #763257
Posted Friday, July 31, 2009 11:03 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:20 PM
Points: 2,897, Visits: 5,979
jdmstar (7/31/2009)
Found the kill bits list through the registry and was able to locate the CLSID, which is:

FA91DF8D-53AB-455D-AB20-F2F023E498D3

Dont know what good that would do me though.


Yes this is the ClsID for the old one that will no longer work on a machine that is patched and up to date.

You could theoretically undo the Killbit that has been set for that CLSID to get it working again, but I would not recommend it. Every month it seems MS is releasing a new set of Killbits. I don't know for sure but I was under the impression that a good number of them are cumulative, so you'd need to reset the killbit every month. That sounds like a maintenance headache to me.

Is there a business reason why you haven't upgraded your reporting services instance to SP3? I really think that do that coupled with downloading the new activex control will go a long way towards solving your problem.

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #763274
Posted Friday, September 25, 2009 5:59 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:42 PM
Points: 667, Visits: 2,055
What version of the rsclientprint.dll do you have? The one that I have that works with all of the winXP patches installed up to and including the one from yesterday is 2005.90.4035 (aka SQL SP3). As I stated earlier I did not install it in System32, I used a custom msi to install it to it's proper place (%windir%\Downloaded Program Files).

Perhaps the 1 machine that is working and the one that isn't working have different versions of the activeX killbits set? Not so much a different version of rsclientPrint.dll


Hi Luke,

I would be very happy if you provide the .msi. We are using SQL Server 2005 SP3 and I have also installed Repoertviewer redistributable SP1 on Report Server.

I tried all the options suggested, but did not work for me. I have also created a .msi (followed the steps given in http://bogdanbrinzarea.wordpress.com/2009/07/07/unable-to-load-client-print-control-and-deploying-rsclientprint-via-msi/) but it also did not work (I'm not an expert in creating .msi though)

So I would like to try your .msi as a last attempt

many thanks
Post #794113
Posted Friday, September 25, 2009 6:03 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:20 PM
Points: 2,897, Visits: 5,979
My MSI will not work for your situation. All you need to do is grab the report view redist cab from your report server and compile one using Visual studio as per the directions posted earlier in this thread.

-Luke.


To help us help you read this

For better help with performance problems please read this
Post #794115
Posted Friday, September 25, 2009 6:45 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 6:42 PM
Points: 667, Visits: 2,055
Hi Luke,

I exactly followed the steps from ( http://bogdanbrinzarea.wordpress.com/2009/07/07/unable-to-load-client-print-control-and-deploying-rsclientprint-via-msi/) but it also did not work!!

any help plz
Post #794120
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse