Can You Install MSDE2000 After You Have Installed SQL Server Express?

I am aware that instances of both can exist on the same machine.

But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000

Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.

I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.

When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.

In the event log, there is an entry

The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR )
cannot be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: (SpnRegister) : Error 1355.

I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc

The result is always the same.

The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)

regards

Stuart

www.mckears.com