Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


RS SP2 install RSCLIENTPrint via cab file, is there an MSI?


RS SP2 install RSCLIENTPrint via cab file, is there an MSI?

Author
Message
Luke L
Luke L
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2682 Visits: 6103


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? :-D

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
Luke L
Luke L
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2682 Visits: 6103
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
jdmstar
jdmstar
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
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?
jdmstar
jdmstar
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
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.
Erik-496633
Erik-496633
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
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?
Erik-496633
Erik-496633
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 49
Wonder what would happen if you delete that CLSID from the Registry?

Does IE8 perform this way on that computer?
Luke L
Luke L
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2682 Visits: 6103
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
gary1
gary1
Right there with Babe
Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)

Group: General Forum Members
Points: 727 Visits: 2232
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
Luke L
Luke L
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2682 Visits: 6103
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
gary1
gary1
Right there with Babe
Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)Right there with Babe (727 reputation)

Group: General Forum Members
Points: 727 Visits: 2232
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search