WMSDE aus WSUS: keine externen Verbindungen möglich

[zahni 521]

Falls jemand mit dem Gedanken spielt die WMSDE nicht nur für den WSUS einzusetzten: Vergesst es. Die WMSDE macht in keinem Fall Port 1433 oder irgendeinen anderen Port auf. Die SQLSERVR.EXE ist auch deutlich kleiner. Dafür gibt es aber für den WSUS keine Größenbeschränkung.

 

Wollte ich nur mal erwähnen, weil neulich ein MS-Mitarbeiter bei einem WSUS-Workshop das nicht erwähnte.

 

-Zahni

[Gadget 37]

Hi Zahni,

 

jo hab da mal ne gute Zusammenfassung gefunden die zwar WMSDE in Kombination mit Sharepoint behandelten, WSUS & WMSDE is von den DB-Beschränkungen auch nix anderes.

 

http://blogs.msdn.com/grahamtyler/archive/2004/10/19/244496.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.

 

LG Gadget