MSDE & SQL Server 2000

I have MSDE 2000 SP3a (default instance) installed and working on my XP Pro
machine, but I'd like to follow some development labs that use the SQL Server
2000 databases. Can I also install SQL Server 2000 3a and if so, what special
'things' must I do to install it?
Dale Cowan
hi Dale,
"Dale" <Dale@.discussions.microsoft.com> ha scritto nel messaggio
news:D5AC5D41-BAA8-4502-B847-06DD990929CF@.microsoft.com...
> I have MSDE 2000 SP3a (default instance) installed and working on my XP
Pro
> machine, but I'd like to follow some development labs that use the SQL
Server
> 2000 databases. Can I also install SQL Server 2000 3a and if so, what
special
> 'things' must I do to install it?
you can only install SQL Server 2000 Developer edition, Personal Edition and
MSDE, on Windows clients platforms... the Standard and Enterprise edition
are only for server platforms...
as long as you install a supported version, you only have to specify a named
instance installation, as your pc already hosts a default instance.
you can have different service pack levels (never tried different localized
versions, but may be =;-D), but the shared binaries in \Program
Files\Microsoft SQL Server\80 folders will be updated at the highes
installed service pack level.
at the moment there's no SQL Server service pack 3 installation, you have to
install the RTM and apply the desired service pack
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
|||RTM?
"Andrea Montanari" wrote:

> hi Dale,
> "Dale" <Dale@.discussions.microsoft.com> ha scritto nel messaggio
> news:D5AC5D41-BAA8-4502-B847-06DD990929CF@.microsoft.com...
> Pro
> Server
> special
> you can only install SQL Server 2000 Developer edition, Personal Edition and
> MSDE, on Windows clients platforms... the Standard and Enterprise edition
> are only for server platforms...
> as long as you install a supported version, you only have to specify a named
> instance installation, as your pc already hosts a default instance.
> you can have different service pack levels (never tried different localized
> versions, but may be =;-D), but the shared binaries in \Program
> Files\Microsoft SQL Server\80 folders will be updated at the highes
> installed service pack level.
> at the moment there's no SQL Server service pack 3 installation, you have to
> install the RTM and apply the desired service pack
> --
> 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 Dale,
"Dale" <Dale@.discussions.microsoft.com> ha scritto nel messaggio
news:610C1A77-A467-4BD9-92E5-BE5B5961AEC2@.microsoft.com...
> RTM?
Release To Manufacturer =;-D
the 1st at al retail version
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
|||Thanks for your help. Everything installed just fine - even MS03-031 security
update afterward. MBSA reports few problems.
"Andrea Montanari" wrote:

> hi Dale,
> "Dale" <Dale@.discussions.microsoft.com> ha scritto nel messaggio
> news:610C1A77-A467-4BD9-92E5-BE5B5961AEC2@.microsoft.com...
> Release To Manufacturer =;-D
> the 1st at al retail version
> --
> 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
>