SQL Clone
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
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4024 Visits: 6128
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
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 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
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 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
Valued Member
Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)Valued Member (65 reputation)

Group: General Forum Members
Points: 65 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
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4024 Visits: 6128
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
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1670 Visits: 2249
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
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4024 Visits: 6128
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
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1670 Visits: 2249
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
jdmstar
jdmstar
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 10
Erik-496633 (7/31/2009)
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?


Yea i already did that. That was the first thing i did during training lol. IF ALL ELSE FAIL export > PDF and save to a dir and then print :-D

Erik-496633 (7/31/2009)
Wonder what would happen if you delete that CLSID from the Registry?

Does IE8 perform this way on that computer?


I dont know if it works like that though i can try it on my LOCAL machine, but then again if it does work, i dont have time to go do it on all 100+ pcs that is located all around the world in different locations and im sure their local IT wouldnt be too happy with me editing the list and reg hacking it.

Luke L (7/31/2009)
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.


The reason is because YES we manage the servers but it is located within a company, and they manage their own PCs so if they update their pcs then obviously we would have to get a memo of this and update or patch our server, but you know how these things work. I didnt get any word of any updates and ALL i got was a crap load of help mail saying the reports wont print.

And we access our servers via VPN so its hard enough to RDP and put files on the server to launch when their network is super locked down.
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