ms sql express problem,can't uninstall/reinstall (1 Viewer)

[AquilaChill]

TV-Server Version: 1.0?
MediaPortal Version: 1.0
MediaPortal Skin: default 4:3
Windows Version: XP Pro SP3
CPU Type: AMD Athlon x2 4800 (brisbane)
HDD: OS WD 80GB (60 for OS),WD320GB,WD1TB
Memory: 1x2GB 6400 (800)
Motherboard: ECS NFORCE6MA
Video Card: MSI ATI Radeon HD 2600XT
Video Card Driver: Catalyst 8.1?
Sound Card: Built in
Sound Card AC3:
Sound Card Driver:
1. TV Card: Hauppauge HVR1600 MCE version (with remote & radio)
1. TV Card Type: Analog+ATSC
1. TV Card Driver:
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case:
Cooling: air, 1x120mm front,1x120mm rear,90mm cpu,90?mm PSU
Power Supply: 650W
Remote: included with TV Tuner
TV:
TV - HTPC Connection:

i was having some sql (ms sql express) related problem causing mp to crash (.net crash dialog), so i thought it would be easier to just start fresh, uninstalled mediaportal+server & then went for sql, its uninstall failed. so im stuck with an uninstallable sql thus no mediaportal.
i tried the mp installer hoping it could just overwrite & be fine, but sql install failed.

what now?

i'd like to have a fresh install of sql & mp without a format or maybe just switch to another program.

 

[craigparris1]

Hi Aquila,

Try this Microsoft KB page on manually removing a SQL Express installation: How to uninstall an instance of SQL Server 2005 manually

Hopefully that will get you to a point where you can re-install SQL again.

Cheers,
Craig

 

[AquilaChill]

thanks
but i don't understand one of the first steps "Delete the local security groups", the page it sends me to doesn't help explain either.

 

[AquilaChill]

but i don't understand one of the first steps "Delete the local security groups", the page it sends me to doesn't help explain either.

bump

 

[neo2001]

thanks
but i don't understand one of the first steps "Delete the local security groups", the page it sends me to doesn't help explain either.

I think it should be no problem to go on with the manual uninstall guide without deleting the groups.

But if you want to, right click on "My Computer", select "Manage". Look for "Local Users and Groups" (something like that), next select "Groups". In there, you should find several Groups starting with "SQLServer..." - delete them. Maybe you have to stop the SQLServer Service(s) first!

 

[AquilaChill]

thanks, but theres no sql groups, theres only one sql named service, vss writer.
vss writer complains on boot about not being able to load or something & stops itself

step1 "Microsoft SQL Server Setup Support Files" is in the list, skip to step2
step2 run "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe" /Remove
error dialog, "ARP Wrapper, Registry enumeration failed."

"Microsoft Internet Information Services (IIS) Manager to delete.." how? its not in Control Panel/Administrative Tools

 

[AquilaChill]

thanks, but theres no sql groups, theres only one sql named service, vss writer.
vss writer complains on boot about not being able to load or something & stops itself

step1 "Microsoft SQL Server Setup Support Files" is in the list, skip to step2
step2 run "%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe" /Remove
error dialog, "ARP Wrapper, Registry enumeration failed."

"Microsoft Internet Information Services (IIS) Manager to delete.." how? its not in Control Panel/Administrative Tools

bump