Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / June 2006

Tip: Looking for answers? Try searching our database.

Can I install more then one copy of MSDE on a server?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Clayton - 27 Jun 2006 22:43 GMT
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
Tom Moreau - 27 Jun 2006 22:52 GMT
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
Clayton - 27 Jun 2006 22:53 GMT
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
Arnie Rowland - 27 Jun 2006 22:54 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.