Cannot uninstall SQL Express 2005 Instances

Using Windows XP SQL Express 2005...

In Windows Installer Clean Up, it shows two instances:

MSSMLBIZ (used by Outlook Enterprice 07 with BCM)

Control, Panel, Add Remove, Remove SQL Express 2005, shows:

CSOLUTION (which is disabled)

MSSMLBIZ (enabled for BCM 07)

SQLEXPRESS (which is disabled)

The disabled instances will not start due to various error messages.

Under Computer, Manager, Services, more instances are listsed, which also will not start:

SQLEXPRESSDATA for example (which is disabled)

I would like to remove CSOLUTION since it is not used; it will not remove from control panel or manually via http://support.microsoft.com/default.aspx/kb/909967 . You get various error messages, such as

Another application has exclusive access to the file c:\program files\...errorlog. Please shut down all other applications, then try again.

Even after a reboot, I still get this error.

I want to install and use instance SQLExpress, and I cannot remove it, but it will not start, and trying to reinstall it fails.

It was simple under MSDE 2000, no2 it seems to be impossible.

Does anyone have any ideas?

Honestly, I would like to uninstall SQL Express 2005 completely (except the BCM instant), and start over, but canot find a way to do this. SQL Express is a mess, I have spent days trying to resolve this, and am still where I started.

Thanks, bob

Which error messages does the SQL Server Express service bring up ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

THe error message is stated in my post. If you do not get that error message, it looks like it is trying to uninstall, but then just returns to the Control panel add/remove listing the instances, with nothing removed and no further error messages.

Thanks,

Bob