Groups | Blog | Home
all groups > sql server msde > november 2005 >

sql server msde : Multiple Databases?



aredneck
11/7/2005 11:26:16 AM
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.
Andre Weidner
11/7/2005 11:29:03 PM
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.

[quoted text, click to view]
bakedmike via SQLMonster.com
11/8/2005 12:00:00 AM
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.

[quoted text, click to view]


--
Message posted via SQLMonster.com
AC
11/9/2005 8:44:24 AM
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?

[quoted text, click to view]
AddThis Social Bookmark Button