You need an existing SQL 2000 installation with SP3. on Windows 2000
or XP.
1. Download MSDE SP3 from Microsoft site and install on 2003 Web.
2. Copy all files to C:\Program Files\Microsoft SQL Server\*.*
from existing installation.
- Do not override new files on 2003 Web with the old one from the
existing installation (Confirm file Replace message box
- Override database files.
- Copy your shortcut
3. Use regsvr32 to register a new DLL (dtsui.dll, sqlmmc.dll and etc.)
- Check this site for some references to bypass this error:
http://www.tkdinesh.com/faq/ans/Snapinfail.html
Snap-in failed to initialize.
Name: Microsoft SQL Enterprise Manager
CLSID: {00100100-1816-11D0-8EF5-00AA0062C58F}]
4. After you restart the server, check if all EXE files can be executed
without any errors.
- You may need some DLL files from existing %SystemRoot%\system32
installation (simply copy to a 2003 Web)
5. Done,
Now you can use your MSDE installation(conversion to SQL 2000 Ent or Dev
Edition.)
I think I didn’t miss anything.