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

Multiple Databases?

I have a server running windows 2000 which I am using as my WSUS server
running a MSDE 2000 DB. I would also like to use this server as my Antivirus
server (Mcafee Protection Pilot). To so this I need to create another MSDE
2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
server? We are primarily a small organization with around 250 users.
Thanks
We got a similiar solution here. We have WSUS and Trendmicro on one Server.
Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
is quite slow and the eventlog complains that the maximum number of
connections was exceeded. Besides that, it works quite well.
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks
|||If you run the MSDE install, you can create another instance of MSDE on the
same server. This might be a better solution than what you resorted to.
Andre Weidner wrote:[vbcol=seagreen]
>We got a similiar solution here. We have WSUS and Trendmicro on one Server.
>Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
>is quite slow and the eventlog complains that the maximum number of
>connections was exceeded. Besides that, it works quite well.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200511/1
|||I've got a similar situation where WSUS is already installed and I'm looking
at moving my anti-virus system on to the same server.
However WSUS is running on Server 2003 and therefore in WMSDE.
I take it I can't use WMSDE for my AV solution so I'd like to know, is it
viable to simply install MSDE 2000 along side WMSDE, or will I have to move
WSUS out of WMSDE and into MSDE 2000?
I assume I'll have some conflicts at minimum with the ports clashing if the
two live together, and there are likely to be other major problems.
Any suggestions?
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks