Answer

The following information is  for Wise Package Studio 7 - 7 SP2 only.  Wise Package Studio 7 SP3 does not support MSDE. You will need to install SQL Express 2005 (see
https://kb.altiris.com/article.asp?article=18249&p=1 for information on installing SQL Express 2005 for use with Wise Package Studio 7 SP3 )

Part 1: Install and configure MSDE:

1. Click here.
2. To download MSDE, click the link titled "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE".
3. Click Run (or Open) and the .exe download and then extract the installation files to C:\SQL2KSP4 (Default folder). Do not execute the setup.exe at this time. It needs to be run from the command line shown in step 4.
4. Execute the command below to install MSDE. (Note: The installation will run a basic dialog.)
   
   <path to Setup.EXE that resides in C:\SQL2KSP4\MSDE > SAPWD="<YourPassword>"
   
   
5. Restart the computer . An icon with a server and a green arrow pointing to the right will appear in the system tray (lower-right corner). If not, check Services under Control Panel > Services and locate SQLSERVERAGENT. Click Start to begin the service.

Part 2: Configure Wise Package Studio 7.x Server installation with MSDE. (These steps are after Package Studio has been set up and the Wise Repository Manager Setup has launched.):

1. In the Database Identification dialog, type the COMPUTERNAME into Server field.
2. In the Database Administrator Login Information dialog, leave the Default selection Windows NT Authentication.
3. During the configuration phase, an information box will appear about the SQL Login Mode. Click OK.
4. Click Finish to complete the New Repository wizard

Wise Package Studio 7.x is ready to use.