Step 2: Install MSDE on Your Server
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 Windows 2000 Server for WSUS 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.
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.
Verify that the MSDE database instance is running.
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 http://go.microsoft.com/fwlink/?LinkId=47366.
To expand the MSDE archive
Double-click the MSDE archive (MSDE2000a.exe).
Read the license agreement, and then click I Agree.
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
At the command prompt, navigate to the MSDE installation folder specified in the previous procedure.
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
Click Start, and then click Run.
In the Open box, type services.msc and then click OK.
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 http://go.microsoft.com/fwlink/?LinkId=47363.
To install SQL Server 2000 (32-bit) Security Patch MS03-031
Double-click SQL Server 2000 (32-bit) Security Patch MS03-031 (SQL2000-KB815495-8.00.0818-ENU.exe).
On the Welcome page, click Next.
Read the End User License Agreement, click I accept the license terms and conditions, and then click Next.
On the Instance to Update page, use the Instance box to select the WSUS instance, and then click Next.
On the Authentication Mode page, select Windows Authentication, and then click Next.
On the Ready to Install page, click Install.
On the Hotfix Complete page, click Finish.