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

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

Arnie Rowland
6/27/2006 2:54:19 PM

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!"]

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

[quoted text, click to view]

Arnie Rowland
6/27/2006 3:07:43 PM

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.

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam

[quoted text, click to view]

Tom Moreau
6/27/2006 5:52:29 PM

Yes, you can. It just requires a different instance name than the other
installed instances.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
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
6/27/2006 6:04:29 PM

That depends on the app. The app may expect a particular instance name, for
example.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?

TIA,

Clayton

[quoted text, click to view]

Clayton
6/27/2006 9:43:59 PM

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
6/27/2006 9:53:40 PM

Or can I just use the same MSDE for the new app.? Can MSDE have more the
one DB?

TIA,

Clayton

[quoted text, click to view]

Clayton
6/27/2006 9:54:55 PM

Can both apps. share the same MSDE install?

TIA,

Clayton

[quoted text, click to view]

Clayton
6/27/2006 10:03:50 PM

Cool, thanks guys. I have to go live with this thing (BlackBerry) within
the hour!

Thanks for your help,

Clayton

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server msde

home · blog · groups

Questions? Comments? Contact the dn