We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton
Yes, you can. It just requires a different instance name than the other
installed instances.

Signature
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
We are running a Windows 2003 domain. I have a Windows 2003 member server
running an app. and MSDE.
I now have another app. that I would like to install on this same server.
The new app. also needs MSDE. My question is can I install and run more
then one copy of MSDE? Is there anything I need to know about doing it?
TIA,
Clayton
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
[quoted text clipped - 6 lines]
>
> Clayton
Clayton - 27 Jun 2006 22:54 GMT
Can both apps. share the same MSDE install?
TIA,
Clayton
> Or can I just use the same MSDE for the new app.? Can MSDE have more the
> one DB?
[quoted text clipped - 13 lines]
>>
>> Clayton
Arnie Rowland - 27 Jun 2006 23:07 GMT
Yes, one instance of MSDE (which is a version of SQL Server) can handle
quite a few databases. Depends on hardware, traffic, etc., subject to the
MSDE sizing limitations.

Signature
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
> Can both apps. share the same MSDE install?
>
[quoted text clipped - 20 lines]
>>>
>>> Clayton
Tom Moreau - 27 Jun 2006 23:04 GMT
That depends on the app. The app may expect a particular instance name, for
example.

Signature
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?
TIA,
Clayton
"Clayton" <none@none.com> wrote in message
news:zEhog.34345$Bh2.22632@fe07.news.easynews.com...
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
[quoted text clipped - 6 lines]
>
> Clayton
You can install up to 16 instances of MSDE (I think that is still
correct -someone correct me if I'm wrong.) on the same server.
However, each additional instance will have a variation in the instance
name. For example, if your server is MyServer, the first installation of
MSDE (or SQL Server) will be know as MyServer. When you install a second
instance of MSDE, you are required to provide an 'instance' name (e.g.,
Accounting). Then that server/instance will be referred to as
MyServer\Accounting. You have to use the compounded name in all connection
strings, etc.
That may not be a simple issue for many third party applications. (I would
hope so -but I've learned to be pessimistic about the skills of a lot of
programmers.)
[Loud retort from over my shoulder ="Hey, I represent that remark!"]

Signature
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
> We are running a Windows 2003 domain. I have a Windows 2003 member server
> running an app. and MSDE.
[quoted text clipped - 6 lines]
>
> Clayton
Clayton - 27 Jun 2006 23:03 GMT
Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!
Thanks for your help,
Clayton
> You can install up to 16 instances of MSDE (I think that is still
> correct -someone correct me if I'm wrong.) on the same server.
[quoted text clipped - 23 lines]
>>
>> Clayton