MSDE 2000 and SQL Server Express 2005 on the same PC

[Database Administrator]

Hi All,

We have Windows XP Sp2 desktops running an application that uses MSDE 2000
(version 8.00.761). If I install another application running MS SQL Server
Express 2005 and it will then the application running MSDE 2000 stops
working. So I install again MSDE 2000 then the application running SQL
Server Express 2005 stops working.

Is there a way to have the two working at the same time ?

Regards,

[Database Administrator]

"JacquesT" wrote in message
news:eX7muAeRJHA.1148@TK2MSFTNGP05.phx.gbl...
> Hi All,
>
> We have Windows XP Sp2 desktops running an application that uses MSDE 2000
> (version 8.00.761). If I install another application running MS SQL Server
> Express 2005 and it will then the application running MSDE 2000 stops
> working. So I install again MSDE 2000 then the application running SQL
> Server Express 2005 stops working.
>
> Is there a way to have the two working at the same time ?

I can't imagine any scenario in which you couldn't have both working
simultaneously!

Perhaps you could share some additional detail on what steps you performed
when you installed these applications (including what the applications are).



--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas

[Database Administrator]

"JacquesT" wrote in
news:eX7muAeRJHA.1148@TK2MSFTNGP05.phx.gbl:

> Hi All,
>
> We have Windows XP Sp2 desktops running an application that uses MSDE
> 2000 (version 8.00.761). If I install another application running MS
> SQL Server Express 2005 and it will then the application running MSDE
> 2000 stops working. So I install again MSDE 2000 then the application
> running SQL Server Express 2005 stops working.
>
> Is there a way to have the two working at the same time ?
>
> Regards,
>
>

I have MSDE 2000 and SQL Server Express 2005 running together on the same
XP SP3 desktop.

What you need to know is that they must have different instance names. You
can have the default for one but the other must have a non-default instance
name. Of course, the applications need to know the instance name of the
server that they are to access.

HTH

[Database Administrator]

"Chris.Cheney" wrote in message
news:Xns9B56AB288642EChrisCheneytesconet@69.16.176 .253...
> "JacquesT" wrote in
> news:eX7muAeRJHA.1148@TK2MSFTNGP05.phx.gbl:
>
>> Hi All,
>>
>> We have Windows XP Sp2 desktops running an application that uses MSDE
>> 2000 (version 8.00.761). If I install another application running MS
>> SQL Server Express 2005 and it will then the application running MSDE
>> 2000 stops working. So I install again MSDE 2000 then the application
>> running SQL Server Express 2005 stops working.
>>
>> Is there a way to have the two working at the same time ?
>>
>> Regards,
>>
>>
>
> I have MSDE 2000 and SQL Server Express 2005 running together on the same
> XP SP3 desktop.
>
> What you need to know is that they must have different instance names. You
> can have the default for one but the other must have a non-default
> instance
> name. Of course, the applications need to know the instance name of the
> server that they are to access.

Even this should be a non-issue as a default installation of SQL Server
Express Edition will auto-install to the named instance 'SQLEXPRESS', which
I doubt any MSDE2000 was visionary enough to have considered.


Even if the MSDE2000 was installed as a 'default' instance (and I'm not sure
it can be, or that any application would have done that), it would require
an explicit attempt to install the SQL Server 2005 Express Edition on the
default instance, and if that were being done, it would actually *upgrade*
the MSDE2000 installation (or abort)...

So, having been through all of that, I'm still trying to reconcile "... the
application .. stops working.."

--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas