Friday, February 10, 2012

Can I install SQL 7 and MSDE on the same machine?

can someone please help me find any documents on this question or answer the
question please.
Thanks in advance
Ray
hi Ray,
Ray wrote:
> can someone please help me find any documents on this question or
> answer the question please.
>
you can install SQL Server 7.0 and MSDE 2000 on the same pc... the SQL
Server 7.0 server will be the default instance as the 7.0 version had no
concept of named instances, where the MSDE 2000 instance will be a named
instance..
just a caveat... MSDE 2000 will install MDAC 2.6 at least (sp4 installs 2.8
sp1) and all COM objects like SQL-DMO, SQL-NS ant the like will be upgraded
at 2000 version, where the client tools like Enterprise Manager, Query
Analyzer, Profiler and so on will remain at 7.0 level as MSDE does not
provide them...
hope EM will still work...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment