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!