MSDE is the desktop version of MSSQLServer, not only in Win2000, WinXP system installation, but also installed on Win98, WinMe, much smaller than MSSQLServer. (I have not tested it on Win95)
First to Microsoft Download
MSDesp3
Compare its previous version, from the original 30 megons of 90 megabytes, it is really for Microsoft ING
This is a compressed file, performs direct execution and decompression to a directory such as: i: / swk / msde2000
Be generated
I: / swk / msde2000 / msi
I: / swk / msde2000 / msm
I: / swk / msde2000 / setup
Three subdirectories.
If the system has not installed Windows Installer, first enter the MSI directory to perform instimsiw.exe
Then enter the setup directory with the command line (note must use the command line, of course you can also write a batch file)
Execute SQL2000.msi SecurityMode = SQL SAPWD = 1111
Installation, 1111 is the connection password for SA, don't know why this SP3 can't be empty, if it is empty, use only trust connection mode in the back.
After the installation is complete, if you install this thing for the first time, you may need to restart the machine.
If MSDE is not started, you can start it with the command line NET Start Mssqlserver.
Test, command line execution OSQL -S machine name -U SA -P 1111
Then enter 1> prompt, at this time, you can knock some SQL to test.
Use [master]
Go
Select * from [sysusers]
Go
System user records should be found.
If each step is correct, it should not be wrong, and if you installed on Win9x, you can only use trust connection.
