How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Content Management Server (814084)


The information in this article applies to:

  • Microsoft Content Management Server 2001
  • Microsoft Content Management Server 2002
  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 2000 (all editions) SP1
  • Microsoft SQL Server 2000 (all editions) SP2

SUMMARY

Content Management Server relies heavily on Microsoft SQL Server 7 or SQL Server 2000 to store and provide its content. 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 Content Manager Server database.

MORE INFORMATION

You can use any of the following methods to help protect SQL Server 2000 against the Slammer worm when you are using Content Management 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

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

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

  2. Extract the service pack files to a folder.
  3. Double-click Setup.bat to start the installation.
  4. When the Backward compatibility checklist appears, make sure that the Enable cross-database ownership chaining for all databases check box is not selected (by default, this check box is not selected).
  5. 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, see the information at 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

REFERENCES

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

810474 INF: Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 Service Pack 3

Also, see the SQL Server 2000 Service Pack 3 Readme.htm file.
Modification Type:MajorLast Reviewed:6/27/2004
Keywords:kbhowto KB814084
©2004 Microsoft Corporation. All rights reserved.