SQL Server & MSDE on same machine?

[gcetti@nauticom.net]

Can an individual computer be configured contain both a SQL Server
instance & an MSDE instance?

Our software we charge separate costs depending if they are running on
a MSDE or SQL Server edition, and if they already have SQL Server
running (which they may have installed for some other application), can
we install our MSDE instance on the same machine?

And on the flip side, if they already have a machine that has an MSDE
instance, can the SQL Server install be done over top of that without
affecting the MSDE?

Thanks for any help,
Greg
gcetti@nauticom .net

[Erland Sommarskog]

Re: SQL Server & MSDE on same machine?

gcetti@nauticom .net (gcetti@nautico m.net) writes:[color=blue]
> Can an individual computer be configured contain both a SQL Server
> instance & an MSDE instance?[/color]

You can install several instances of SQL Server of the same machine,
and that can be a mix of different editions, including MSDE.

What you cannot do, though, is to use the graphical tools from
standard/enterprise edition to access MSDE. Technically, it works
all right, but it violates the license agreement.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp