From this page, select your preferred language and click Go. Scroll down to the bottom of the page you are redirected to and download the MSDE2000A.exe file to your computer. 2. When the executable has been downloaded to your computer, double-click the file to begin the installation. 3. The first screen that appears is the license agreement; click I Agree to continue. 4. You are asked to provide the path to the location where the installer package will unpack the required setup files. Accept the default C:\MSDERelA path and click Finish. The files are unpacked to the MSDERelA folder within the root of C:\. 5. Open the Command Prompt by selecting Run from the Start menu; type CMD and click OK. 6. In the Command Prompt, change to the directory where you extracted the files by typing the CD command as follows:   CD C:\MSDERelA 7. Run the following command to set up MSDE:   Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR PASSWORD>   It's extremely important that you type a unique password for the SAPWD parameter. MSDE needs this value to begin the installation. 8. MSDE now installs. When it finishes, close the Command Prompt. Now that you've successfully installed MSDE, you're ready to start the service. The easiest way to start the MSDE service is to launch the service manager. You can do this by following these steps: 1. Click Start, Programs, Startup and choose the Service Manager option. The SQL Server Service Manager opens, similar to Figure 23.12. Figure 23.12. The SQL Server Service Manager allows you to start and stop MSDE. 2. Type YOURCOMPUTERNAME\NETSDK in the Server drop-down list box (where YOURCOMPUTERNAME is the network name of your computer), and click Refresh Services. MSDE should then connect, and the green triangle should appear. 3. Click the Start/Continue icon to start MSDE. 4. Close the SQL Server Service Manager. After you close the Service Manager, it continues to run out of sight in the system tray. You'll notice a small icon that looks like a cylinder with a play icon on top. Web Data Administrator To use MSDE effectively, you'll need to download and install the Web Data Administrator. Web Data Administrator is a free DBMS provided by Microsoft that allows you to manage your instance of MSDE locally and remotely using a web-based interface. What's nice about Web Data Administrator, aside from the fact that it's free, is that it lets you manage databases, tables, columns, column types, stored procedures, and more. To download and install Web Data Administrator, follow these steps: 1. Navigate to http://www.microsoft.com/downloads/details.aspx?FamilyId=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en and click the download button to begin the download of the WebDataAdmin.msi file. 2. After you've downloaded the file, double-click the .MSI file to install Web Data Administrator. after it's installed, you can access the Web Data Administrator through your browser at the URL http://localhost/SqlWebAdmin. Before you can use it however, you must enable what is known as SQL Mixed Mode authentication. This process