Step 2: Install MSDE on Your Server (Windows 2000 only)

  • Article

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2, Windows Server Update Services

If you are using WSUS with Windows 2000 Server and do not have access to Microsoft SQL Server 2000, you should install Microsoft SQL Server 2000 Desktop Engine (MSDE) prior to running WSUS Setup. This section gives step-by-step instructions for this task.

If you are installing to a Windows Server 2003 operating system, you do not need to do this step; skip to Step 3: Install WSUS on Your SUS Server

Installing MSDE on Windows 2000 Server is a four-step process. First, you must download and expand the MSDE archive to a folder on the server you want to be your WSUS server. Next, at the command prompt, use command-line options to run MSDE Setup, set the sa password, and assign WSUS as the instance name. Then, when the MSDE installation finishes, you should verify that the WSUS instance is running as a Windows NT service. Finally, you must add a security patch to MSDE to protect your WSUS server.

Step 2 contains the following procedures:

  • Download and expand the MSDE archive.

  • Install MSDE.

  • Verify that the MSDE database instance is running.

  • Update MSDE.

You must download and expand the MSDE archive to a folder on the server you want to be your WSUS server. To obtain SQL Server 2000 Desktop Engine (MSDE 2000) Release A, go to the Download Center at https://go.microsoft.com/fwlink/?LinkId=47366.

To expand the MSDE archive

  1. Double-click the MSDE archive (MSDE2000a.exe).

  2. Read the license agreement, and click I Agree.

  3. In the Installation Folder box, type a path, and then click Finish. For example, type C:\MSDE2000. The MSDE archive copies MSDE installation files to the installation folder you specify.

Now you install MSDE, set the sa password, and assign an instance name.

To install MSDE, set the sa password, and assign an instance name

  1. At the command prompt, navigate to the MSDE installation folder specified in the previous procedure.

  2. Type the following:

    setup sapwd="password" instancename="WSUS"

    where password is a strong password for the sa account on this instance of MSDE. This command launches the MSDE setup program, sets the sa password, and names this instance of MSDE to WSUS.

To verify that the WSUS instance of MSDE was installed

  1. Click Start, and then click Run.

  2. In the Open box, type services.msc and then click OK.

  3. Scroll down the list of services, and verify that a service named MSSQL$WSUS exists.

You must download and install the security patch described in the bulletin,"MS03-031: Cumulative Security Patch for SQL Server." To obtain SQL Server  2000 (32-bit) Security Patch MS03-031, go to the Download Center at https://go.microsoft.com/fwlink/?LinkId=37271.

To read bulletin MS03-031, go to the Microsoft Help and Support Web site at https://go.microsoft.com/fwlink/?LinkId=37270.

To install SQL Server 2000 (32-bit) Security Patch MS03-031

  1. Double-click SQL Server 2000 (32-bit) Security Patch MS03-031 (SQL2000-KB815495-8.00.0818-ENU.exe).

  2. On the Welcome page, click Next.

  3. Read the End User License Agreement, click I accept the license terms and conditions, and then click Next.

  4. On the Instance to Update page, use the Instance box to select the WSUS instance, and then click Next.

  5. On the Authentication Mode page, select Windows Authentication, and then click Next.

  6. On the Ready to Install page, click Install.

  7. On the Hotfix Complete page, click Finish.