MSDE 2000 and SQL Server Express 2005 on the same PC

"JacquesT" wrote in


> 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
 >> Stay informed about: MSDE 2000 and SQL Server Express 2005 on the same PC 

"Chris.Cheney" wrote in message

> "JacquesT" wrote in
>
>
>> 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
 >> Stay informed about: MSDE 2000 and SQL Server Express 2005 on the same PC 

Hello,

So they should work together without any problems. It seems to me that it's
the same as if you had two MSDE 2000 instances installed on the same
computer. As long as instance names are different they will work together on
the same box.

Thanks guys!!

"Lawrence Garvin" a écrit dans le message de
%23P3YJStRJHA.4992@TK2MSFTNGP05.phx.gbl...
> "Chris.Cheney" wrote in message
>
>> "JacquesT" wrote in
>>
>>
>>> 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
>
 >> Stay informed about: MSDE 2000 and SQL Server Express 2005 on the same PC 

"JacquesT" wrote in message

> Hello,
>
> So they should work together without any problems. It seems to me that
> it's the same as if you had two MSDE 2000 instances installed on the same
> computer. As long as instance names are different they will work together
> on the same box.

Exactly.


--
Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
Principal/CTO, Onsite Technology Solutions, Houston, Texas
 >> Stay informed about: MSDE 2000 and SQL Server Express 2005 on the same PC 

Thanks Lawrence!

"Lawrence Garvin" a écrit dans le message de
OthqSGcSJHA.5364.RemoveThis@TK2MSFTNGP05.phx.gbl...
> "JacquesT" wrote in message
>
>> Hello,
>>
>> So they should work together without any problems. It seems to me that
>> it's the same as if you had two MSDE 2000 instances installed on the same
>> computer. As long as instance names are different they will work together
>> on the same box.
>
> Exactly.
>
>
> --
> Lawrence Garvin, M.S., MCITP(x2), MCTS(x5), MCP(x7), MCBMSP
> Principal/CTO, Onsite Technology Solutions, Houston, Texas
>
 >> Stay informed about: MSDE 2000 and SQL Server Express 2005 on the same PC