Monday, March 19, 2012

MSDE & WMSDE

What is the diffrence between MSDE 2000 and WMSDE? I have two applications
that require these databases and I am concerned there might be issues in
using them on the same server:
SmarterTicket / MSDE 2000
Windows SharePoint Services / WMSDE
Thanks - Jody
hi Jody,
Jody wrote:
> What is the diffrence between MSDE 2000 and WMSDE? I have two
> applications that require these databases and I am concerned there
> might be issues in using them on the same server:
> SmarterTicket / MSDE 2000
> Windows SharePoint Services / WMSDE
> Thanks - Jody
WMSDE is a customized version of MSDE 2000 distributed along with and only
available with SharePoint...
it has been modified to fit SharePoint needs and you should avoid using it
for your own databases..
I do not have a WMSDE eula available, but I think it prohibits a shared use
with other apps and related databases..
install 2 separated instances, 1 of WMSDE to be used by SharePoint and
another MSDE one to be used by your other apps.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
In reference to you comment:
"...it has been modified to fit SharePoint needs and you should avoid using
it for your own databases..."
Do you mean that I should avoid using WMSDE with WSS or along side of
SmarterTicket becasue it uses MSDE?
Thanks - Jody

> hi Jody,
> Jody wrote:
> WMSDE is a customized version of MSDE 2000 distributed along with and only
> available with SharePoint...
> it has been modified to fit SharePoint needs and you should avoid using it
> for your own databases..
> I do not have a WMSDE eula available, but I think it prohibits a shared use
> with other apps and related databases..
> install 2 separated instances, 1 of WMSDE to be used by SharePoint and
> another MSDE one to be used by your other apps.
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Jody,
Jody wrote:
> Andrea,
> In reference to you comment:
> "...it has been modified to fit SharePoint needs and you should avoid
> using it for your own databases..."
> Do you mean that I should avoid using WMSDE with WSS or along side of
> SmarterTicket becasue it uses MSDE?
I mean WMSDE should be used only by SharePoint and let SmarterTicket uses
another MSDE instance ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment