Painful experience of installing SQL Server 2005 Service Pack 1

I didn't realized that I was opening such a big can of worm when I started installing SQL Server 2005 Service Pack 1. But darn here I went.

First I found out that I COULDN'T even proceed SQL Server 2005 SP1 update. It kept bitching me about not being able to authenticate. Back then my machine has nothing in it. Then I wapped out the machine, installed Visual Studio .Net 2005. And then installed SQL Server 2005, and at the end of SQL Server 2005 installation, I install the SQL Server 2005 right away. And darn it worked.

But then after I rebooted, and found that the SQL Server Integration Services was not able to start up at all. Then I found a TechNet article about the BUG and the corresponding hotfix. So I installed the hot fix, and finally have the problem resolved. Notice that you need to install the hotfix .exe in PROPER order, and you can find the order here.

Messy.