Re: WSS & WMSDE

http://blogs.msdn.com/grahamtyler/archive/2004/10.aspx

"Windows SharePoint Services (WSS) is a Windows Server 2003 component,
and if SPS 2003 is not installed WSS uses a special version of MSDE,
known as SQL Server 2000 Desktop Engine (Windows), or WMSDE. This is an
unthrottled version of MSDE designed only to be used by Windows
components, and as such is not limited in the same way as MSDE. The
maximum size limit and current connections limit have both been
removed. However it is still much more limited than SQL Server 2000 in
the following ways:

WMSDE does not include enterprise management tools such as those
provided with SQL Server 2000 (e.g. SQL Enterprise Manager MMC tool)
for backing up and restoring the database. However command line tools
can still be used (e.g. stsadm tool).

WMSDE can only be managed locally - you cannot remotely connect

WMSDE does not support full-text search - so search from within team
sites is not possible

You cannot deploy WMSDE in web farm/clustered configurations, so the
solution cannot scale beyond certain limits, and remains a single point
of failure.

You cannot use WMSDE for anything other than WSS due to the custom
schema it uses (MSDE or SQL Server 2000 can also be used for other
custom applications). There is no user interface to edit the database
file."

.

Relevant Pages

  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)