Multiple instances : WSUS and ProtectionPilot

Hi,
I first installed sucessfully WSUS on my Win2000 Adv Server (SP4).
Then, I would like to install McAfee ProtectionPilot which
also uses MSDE.
It seems that I cannot install multiple DB instances on MSDE.
Is that true ?
TIA.
Eric
hi Eric,
user@.domain.invalid wrote:
> Hi,
> I first installed sucessfully WSUS on my Win2000 Adv Server (SP4).
> Then, I would like to install McAfee ProtectionPilot which
> also uses MSDE.
> It seems that I cannot install multiple DB instances on MSDE.
> Is that true ?
you can (actually could, never tried my self) to register up to 32767
databases per each SQL Server/MSDE 2000 instance...
and each server can host up to 16 different instances of SQL Server/MSDE
2000, where 1 can be the default instance and the other have to be named
instances..
http://msdn.microsoft.com/library/de...setup_2xmb.asp
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