SQL Server 2008 Fix: SP1 Install Failure

 

For quite a while I could not install SQL Server 2008 SP1, as it reported a failed shared component installation – in this case, Books Online. Problem is I could not find the source MSI to fix it.

So here is how I solved the problem:  If any shared components installations result in a failed state, a Registry key is updated. SP1 reads these keys when it starts, and if the value is not “1” (in my case it was “3”) – it will stop. Seems ridiculous to me, but that’s how they do it.

And doing a repair may not fix it either – because you may have installed Books Online from an interim standalone MSI installer. if you try to find the original MSI to handle the repair, it might not be the correct one.

Edit this key (or the respective key for whatever your fail message says) and ensure that the value is 1:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\ConfigurationState\Sql_BooksOnline_Redist

That took care of that problem! Now I have a different issue, but I’ll tackle that one too. Hey! Its us against them!

Another little Gem Department

If you have ever used Alt-PrtScn to get a quick screen capture of an image for pasting into an article or blog post, you may have brought up MS Paint to CTRL-V paste it in there. The problem is, you get your image – but the canvas size may be much bigger. If you forget to drag the sides of the canvas in to match the size of the image before you save it, you may be very disappointed at the results!

Comments

  1. Anonymous10:26 AM

    Re: the screenshot gem...I prefer to use Paint.NET because when you choose to create a new image when there is one on the clipboard, it defaults the new image size to match. If you don't have Paint.NET (crazy talk, I know) you can leave your default image size in MS Paint small and it will auto-expand to just the right size as you paste in your screenshot, etc.

    ReplyDelete
  2. mario1:48 AM

    thanks! that worked for me

    ReplyDelete
  3. Anonymous5:34 AM

    hi,
    I got the same probleem with SP1. I was updating the aql server via WSUS en it keeps giving me failed status.I couldn't see the last piece of reg key with "Sql_Booksonline_Redist"

    any idea's which key I have to remove?
    Thanks in Advance,
    Ted

    ReplyDelete
  4. Teddiz5:35 AM

    hi,
    I got the same probleem with SP1. I was updating the aql server via WSUS en it keeps giving me failed status.I couldn't see the last piece of reg key with "Sql_Booksonline_Redist"

    any idea's which key I have to remove?
    Thanks in Advance,
    Ted

    ReplyDelete

Post a Comment

Popular posts from this blog

FIREFOX / IE Word-Wrap, Word-Break, TABLES FIX

One of the most annoying things a developer (who would normally delight in writing code, not futzing with markup) can have is getting rendering issues between different browsers. The two biggest players are of course Internet Exploder and Firefart (as I lovingly like to refer to each). In most cases that's going to take care of 98 percent of your total site traffic. IE has had a proprietary "word-break" style attribute for a long time, and this made it into the CSS 3.0 spec. But that doesn't necessarily help you with Firefox right now. Firefox literally - (and I consider this completely idiotic, since it's been in their bug database for FIVE YEARS) does not have a reliable CSS style element to force table cell content to break in the middle of a word in order to stop the content from expanding your table / div off the page or over other content on the page. Here's a partial fix, which will work for most tables and browsers. The style declaration (I call it m
Read more

Some observations on Script Callbacks, "AJAX", "ATLAS" "AHAB" and where it's all going.

I've taken a more than cursory interest in the whole Remote Scripting (.NET species) vs. AJAX and now ATLAS discussion, mostly because I started using Remote Scripting since Microsoft first released it, and because I continued to refine it after seeing Brent Ashley's excellent work with JSRS, which was one of the first "real" cross-browser solutions back in 2000 (that's the turn of the Century for you history buffs). Now Bertrand Leroy, a Microsoft guy whose work I like , has authored some very interesting ASP.NET 2.0 script callback stuff that he points to on his blog, and he is obviously (at least, to me he is) involved quite heavily in the development of this new ATLAS infrastructure that they'll preview at PDC. Leroy's most recent post brings to the surface what I agree are the major differences between the "AJAX a - la .NET" approach as popularized by Michael Swartz with his AJAX.NET library, and Leroy's RefreshPanel, the ASP.NET 2.0 b
Read more

IE7 - Vista: "Internet Explorer has stopped Working"

Image
This one was a bitch. All of a sudden for no reason at all, out of the blue, I get this dialog "internet Explorer has stopped working". I didn't install any new software, crap- I didn't do anything! So here I am using FIREFART to go on the internet and find out what to do! Damn! Good thing I've got the sucker on the same machine (I'm not "anti-Firefox", i just don't use it that much except to check my page renderings). The Fix The fix (at least for me): 1) Go into Control Panel, and choose "Internet Options". 2) Under the "Advanced" tab, press the "RESET" button at the lower right: Don't ask me why this happens, or why the fix works. That's a BUG, D00D - I don't care how you slice it!
Read more