Answer: The SQL Server 2000 Microsoft Desktop Engine (MSDE) is included with Microsoft Office XP (all editions) as well as the stand-alone edition of Microsoft Access XP. MSDE is not installed as part of the standard Microsoft Office or Access setup; you have to run a separate setup program to install it. If you do not have an Office or Access XP setup CD, you can download a free copy of the SQL Server 2000 MSDE from the Microsoft web site as described in the next section.

Download MSDE 2000 Setup Files

1. Go to the MSDE 2000 Downloads web page and download the MSDE 2000 Release A setup file.
2. Using Windows Explorer, locate the download folder and double-click on the MSDE2000A.exe file. When asked, specify the folder where the installation files are to be extracted.
3. After extracting the setup files, browse to the extracted folder location and open the ReadmeMSDE2000A.htm file for installation instructions.

Install MSDE 2000

The MSDE 2000 setup utility does not have a graphical user interface to walk you through the setup process. Instead, the utility accepts a set of parameters that you can enter using your Windows command prompt. For a detailed description of the parameters, refer to the ReadMe file. However, for most initial installations, you can use the following abbreviated steps:

1. From the Windows taskbar, select Start / Run... to open the command prompt.
2. Enter the setup command by substituting your own extracted folder and strong password as follows:
3. C:\Extracted_Folder\setup SAPWD="password" SECURITYMODE = SQL DISABLENETWORKPROTOCOLS=0
4. Click the OK button to run the setup program using the given parameter settings.
5. Once MSDE is installed on your computer, you can either restart the computer or start the SQL Server services by selecting Control Panel / Administrative Tools / Services, double-clicking Services to display a list of service items. Scroll down in the list to find MSSQLServer and click the Start Service link.

You can also start the server component by using the SQL Server Service Manager. To do this, double-click the SQL Server Service Manager icon on the taskbar, make sure MSSQLServer is selected in the Services list, and then click Start/Continue. If necessary, you can change the MSSQLServer service to start automatically by selecting the Auto-start service when OS starts check box in the SQL Server Service Manager window. If the SQL Server Service Manager icon isn't available on the taskbar, you can start it from the Windows Start menu by pointing to Programs, then pointing to MSDE, and clicking Service Manager.

Attach Catalyst Database

1. If you have not done so already, move the mdf and ldf SQL Server database files from the Catalyst application folder to the Data folder of the SQL Server target directory. The default target directory from the steps above would be something like:
   C:\Program Files\Microsoft SQL Server\MSSQL\Data
2. Refer to the Catalyst help topic, SQL Server Setup, for instructions on attaching a back-end database file to the server.