Click here to Skip to main content
15,867,453 members
Articles / Database Development / SQL Server
Article

Trouble with Installing SQL 2005 After Uninstalling CTP/Beta

Rate me:
Please Sign up or sign in to vote.
3.59/5 (5 votes)
17 Dec 20052 min read 43.3K   14   6
After uninstalling the SQL Server 2005 CTP, if you are unable to install the release version, here is what you should do.

Introduction

I installed the CTP of Microsoft SQL Server 2005 that came with my MSDN subscription months ago. I did this foolishly on my primary workstation without doing it in a Virtual Server or PC environment. I never used it and uninstalled it a few weeks later.

Today, after finally taking the leap and deciding to move forward and start using Visual Studio 2005 and SQL Server 2005, I attempted to install these on the same workstation. The SQL Server installation failed and complained about the Beta version still being installed. The only help that I got from the installation media readme told me to use Add/Remove Programs to uninstall any previous versions; that was a wash since Add/Remove Programs showed none. I jumped to Google and Yahoo! for the answers, and found a lot of articles about SQL Server 2005 CTP and the installation of it, but nothing pertaining to my problem. To make a long story short, I spent about two hours trying to find the answer to the problem from outside sources when the answer was all-the-while housed on my hard drive.

I did not retain any of this information, so the details are "fuzzy", but after going through this ordeal, I talked to a few friends who had reformatted their hard drives because of this issue. This is completely unnecessary and I hope to help people avoid this in future. The setup generates some log files when it fails (which I've already deleted, so some of the exact details are lost to me). For me, these files were in C:\Program Files\Microsoft SQL Server\90\SetupBootstrap\Files I believe. Inside of one of these files, which was very short and nothing to be intimidated by, there was a clear indication as to why the installation failed. It was searching the registry and found some entries that told it the CTP release was still installed. It gave me the handy ID of the culprit in the log file (for me {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}) along with some other information that could be used instead. I simply sparked up regedit, searched for {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}, and deleted anything that I saw.

Now, before anyone goes out deleting registry entries, it takes some caution and you might want to backup any keys before you delete them. Some of the entries that I deleted were Keys and some were Values. It was dependant on my interpretation of what to delete, but if your alternative is reformatting your computer, you might want to try this first.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
QuestionDo u have another solutuin Pin
alex_kl24-Feb-06 8:28
alex_kl24-Feb-06 8:28 
AnswerRe: Do u have another solutuin Pin
Dewey Vozel26-Feb-06 10:44
Dewey Vozel26-Feb-06 10:44 
GeneralYour effort is appreciated.... Pin
metaxiom18-Feb-06 11:38
metaxiom18-Feb-06 11:38 
GeneralRe: Your effort is appreciated.... Pin
Dewey Vozel20-Feb-06 17:44
Dewey Vozel20-Feb-06 17:44 
GeneralThanks a lot Pin
jamesxd20-Dec-05 8:02
jamesxd20-Dec-05 8:02 
GeneralThanks...Will try again Pin
schwinbp20-Dec-05 3:09
schwinbp20-Dec-05 3:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.