See also: SQL Server

• How to Throttle BCM (or any other SQL Express database) memory usage
• Allocated Memory Alert in SBS for SQL instances (eg. SBSMONITORING)
• MSDE 2000 Product Information
• How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition

Installing MSDE

When installing MSDE manually you need to supply the "sa" password on the command line - setup.exe SAPWD="your_password"

After installing, you probably want to change your authentication mode from "Windows authentication" to "mixed mode authentication". Change the value of HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode from 1 to 2. (more info).