Installing MSDE

Being new to setting up MSDE, we are currently testing crystal reports
and Microsoft Sharepoint services. We want to install these on a
seperate server and see that they use MSDE. We also have a server
currently installed with MSDE for Altiris deployment images and HP
insite manager. Is it a good practice to link to the existing MSDE
server or house this instance of MSDE on the new test server.
Thanks
John
hi John,
JohnC wrote:
> Being new to setting up MSDE, we are currently testing crystal reports
> and Microsoft Sharepoint services. We want to install these on a
> seperate server and see that they use MSDE. We also have a server
> currently installed with MSDE for Altiris deployment images and HP
> insite manager. Is it a good practice to link to the existing MSDE
> server or house this instance of MSDE on the new test server.
usually it's considered a good practice to separate the database server from
the application server both for security reasons and performance reasons, in
order to have a "dedicated" machine for each task...
just a caveat.. Sharepoint usually requires a lot of database space and
ships with a dedicated MSDE version, known as WMSDE, which has been modified
by Microsoft to remove the 2gb limit for each database.. WMSDE is shipped
only with Sharepoint and can only be (legally) used by it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea for your info, looking at the big picture and future
expansion. Taking on board your info about a dedicated database server,
are we better off having an sql server and all are database accessing
software linking up to it like Altiris, sharepoint, crystal reports,
and our own web site which at the moment is linked to mysql.
Regards
John