Monday, November 10, 2008

SQL Server - A long day and a longer night

This isn't music related, this is my software job. I had to uninstall Microsoft SQL Server 2005 yesterday because the default instance became corrupt. Now, I won't get into a lot of detail on it, but suffice to say that if an instance becomes corrupt, the uninstall won't remove it completely, and the re-install won't install over top of it.

You end up in this "you can't get there from here" space.

Well, you can get there. Basically, you have to uninstall as far as you can, and then start crawling through the registry removing references to SQL server, going into the Program Files directory and removing files. The final trick was how to remove a Vista service that doesn't show up in msconfig - and this article should help you should you have such an arcane requirement in the future.

So now I'm back up and running where I was yesterday at noon, only backlogged. I'll be getting to the equalization shortly.

No comments:

Post a Comment

Thanks for thinking to comment on my blog.