MS SQL Server - Uninstall/Reninstall Help!

Author

Uninstall/Reninstall Help!

Kevin Thomas

2006-10-24, 6:37 pm

System: IBM ThinkPad running Windows XP Pro 2002 SP2

Problem: MSDE and Microsoft SQL folders were manually deleted from within
C:\Program Files. Now I am unable to get MSDE or SQL to install
successfully again. I tried to re-install my original version of SQL and
MSDE, but the attempt failed, producing an error message: "The SQL Server
service failed to start." I downloaded Microsoft "SQL Server 2000 Desktop
Engine (MSDE 2000) Release A" and tried to install that, but nothing happens
(2 popup windows appear briefly and disappear.) I tried to clean the
registry of "msde" and "sql" entries, and tried installing SQL and MSDE
again, but that didn't help. I am now at the point where I am considering
reformatting the C: drive. Does anyone know of any other alternatives? Am I
doing something wrong in my recovery attempts?

Geoff N. Hiten

2006-10-24, 6:37 pm

Here is how to clean out a broken SQL 2000 instance:

How to manually remove SQL Server 2000 default, named, or virtual instance
http://support.microsoft.com/kb/290991/en-us

If you work with SQL Server long enough, you will find yourself dealing with
a brokern install. Welcome to the club.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Kevin Thomas" <kthomas00@verizon.net> wrote in message
news:eKoaQXv7GHA.3340@TK2MSFTNGP04.phx.gbl...
> System: IBM ThinkPad running Windows XP Pro 2002 SP2
>
> Problem: MSDE and Microsoft SQL folders were manually deleted from within
> C:\Program Files. Now I am unable to get MSDE or SQL to install
> successfully again. I tried to re-install my original version of SQL and
> MSDE, but the attempt failed, producing an error message: "The SQL Server
> service failed to start." I downloaded Microsoft "SQL Server 2000 Desktop
> Engine (MSDE 2000) Release A" and tried to install that, but nothing
> happens (2 popup windows appear briefly and disappear.) I tried to clean
> the registry of "msde" and "sql" entries, and tried installing SQL and
> MSDE again, but that didn't help. I am now at the point where I am
> considering reformatting the C: drive. Does anyone know of any other
> alternatives? Am I doing something wrong in my recovery attempts?
>

coenzyme

2006-10-24, 6:37 pm

Kevin,
I experienced a similar problem during a reinstall of 2005 . I
discovered a Microsoft tool called InstallerCleanUP. I displays a
msicuu2.exe. After I ran it, the reload worked.If you try it, let me know if
it works.
R.,
Ed

"Kevin Thomas" wrote:

> System: IBM ThinkPad running Windows XP Pro 2002 SP2
>
> Problem: MSDE and Microsoft SQL folders were manually deleted from within
> C:\Program Files. Now I am unable to get MSDE or SQL to install
> successfully again. I tried to re-install my original version of SQL and
> MSDE, but the attempt failed, producing an error message: "The SQL Server
> service failed to start." I downloaded Microsoft "SQL Server 2000 Desktop
> Engine (MSDE 2000) Release A" and tried to install that, but nothing happens
> (2 popup windows appear briefly and disappear.) I tried to clean the
> registry of "msde" and "sql" entries, and tried installing SQL and MSDE
> again, but that didn't help. I am now at the point where I am considering
> reformatting the C: drive. Does anyone know of any other alternatives? Am I
> doing something wrong in my recovery attempts?
>
>
>

Sponsored Links