MSDE instance/SQL installed

I have an MSDE application and I'm wondering, if SQL Desktop already exists
on the machine its being installed on, what will happen if I try to install
a named instance of MSDE? Will it still install and then show an additional
service in the Services MMC?
Thanks.
STom
hi STom,
"TheNortonZ" <thenortonz@.hotmail.com> ha scritto nel messaggio
news:%235CpOEr5EHA.128@.TK2MSFTNGP15.phx.gbl
> I have an MSDE application and I'm wondering, if SQL Desktop already
> exists on the machine its being installed on, what will happen if I
> try to install a named instance of MSDE? Will it still install and
> then show an additional service in the Services MMC?
> Thanks.
> STom
you can install up to 16 instances (1 default instance and 15 named
instances) on the same pc...
all installed instances will have separate binaries (just the shared part of
them will be "shared" and updated at the highest service pack level),
registry keys, path and folders, and, of course, they will be separately
listed in SQL Server Service Manager and in the Services MMC applet..
the default instance will be listed there as MSSQLSERVER and SQLSERVERAGENT,
while each named instance as MSSQL$instanceName and SQLAgent$instanceName..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
Thanks for the info.
Can I install MSDE2000A on a machine that is currently running SQL Server
2000 SP3a (Developer Edition)? I think you are saying I can.
STom
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:32ogv5F3phms8U1@.individual.net...
> hi STom,
> "TheNortonZ" <thenortonz@.hotmail.com> ha scritto nel messaggio
> news:%235CpOEr5EHA.128@.TK2MSFTNGP15.phx.gbl
> you can install up to 16 instances (1 default instance and 15 named
> instances) on the same pc...
> all installed instances will have separate binaries (just the shared part
> of
> them will be "shared" and updated at the highest service pack level),
> registry keys, path and folders, and, of course, they will be separately
> listed in SQL Server Service Manager and in the Services MMC applet..
> the default instance will be listed there as MSSQLSERVER and
> SQLSERVERAGENT,
> while each named instance as MSSQL$instanceName and
> SQLAgent$instanceName..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
"TheNortonZ" <thenortonz@.hotmail.com> ha scritto nel messaggio
news:%23luGIUu5EHA.3236@.TK2MSFTNGP15.phx.gbl
> Can I install MSDE2000A on a machine that is currently running SQL
> Server 2000 SP3a (Developer Edition)? I think you are saying I can.
yes, you can... and it must be a named instance if SQL Server Dev Edition is
the default instance..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply