MSDE has the basic functions of MSSQL, and smaller, suitable for some simple applications, or you can use. But for security, MSDE's default configuration is not convenient, to do some manual configuration work, summarize MSDE installation and configuration:
Download address
Http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=zh-cn
Download there in CHS_SQL2kDesksp3.exe (already included full installer)
2. Unzip to folders
3. Configure setup.ini
Add SAPWD = XXXX in [Options] (password of SA)
4. Install MSDE
5. Run the SQL Server 2000 installer, install server management tools
6. (Undebementing Whether you must) Install SQL Server SP3
7. Run SVRNETCN, enable naming pipes and TCP / IP protocol
8. If necessary, run the Enterprise Manager, configure server properties à security à Authentication mode for SQL Server and Windows
9. If necessary, run
Services.msc
Setting up
MSSQLServer
Service is automatic
