How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Commerce Server (814109)

SUMMARY

Commerce Server uses Microsoft SQL Server 7.0 or SQL Server 2000 to store its administration and site databases. However, SQL Server may be vulnerable to the recent Slammer worm as described in the following Microsoft Knowledge Base article:

813440 Virus Alert About the W32.Slammer Worm

This article describes how to install SQL Server 2000 Service Pack 3 (SP3) or post-Service Pack 2 security patch MS02-061on a SQL Server-based computer that houses a Commerce Server database.

MORE INFORMATION

You can use either of the following methods to help protect SQL Server 2000 against the Slammer worm when you are using Commerce Server:

Install Service Pack 3 (SP3) on SQL Server.
Install post-Service Pack 2 (SP2) security patch MS02-061 on SQL Server.

Install SP3 on SQL Server 2000

To download the correct service pack for your installation of SQL Server, visit the following Microsoft Web site:

http://www.microsoft.com/sql/downloads/2000/sp3.asp

To install the service pack, follow these steps:

Extract the service pack files to a folder, and then double-click Setup.bat to start the installation.
Complete the installation process, and then follow the recommendation to back up the master databases.

Install Post-SP2 Security Patch MS02-061 on SQL Server 2000

To install security patch MS02-061 on SQL Server 2000, visit the following Microsoft Web site:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS02-061.mspx

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

316333 INF: SQL Server 2000 Security Update for Service Pack 2