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

MORE INFORMATION

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

Install post-Service Pack 2 (SP2) security patch MS02-061 on SQL Server.
Install post-SP2 security patch MS02-061 on Microsoft SQL Server 2000 Desktop Engine (MSDE) if you are using Microsoft BizTalk Server 2002, Partner Edition.
Install Service Pack 3 (SP3) on SQL Server.
Install SP3 on MSDE if you are using BizTalk Server 2002, Partner Edition.

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

Also, see the following Microsoft Knowledge Base article:

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

Install Post-SP2 Security Patch MS02-061 on MSDE

To install security patch MS02-061 on MSDE, see the information at the following Microsoft Web site:

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

Also, see the following Microsoft Knowledge Base article:

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

Install SP3 on SQL Server 2000

To install SQL Server 2000 SP3, visit the following Microsoft Web site:

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

Notes

For additional information about how to determine your current version of SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
To update SQL Server core components, download and install Sql2ksp3.exe.
While you are installing SP3, it is a good idea to leave the default setting for Cross-Database Ownership Chaining as Disabled.

Install SP3 on MSDE

To install SP3 on MSDE, visit the following Microsoft Web site:

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

To update MSDE, download Sql2kdesksp3.exe.
Extract Sql2kdesksp3.exe into a local folder.
Start a command prompt, and the run the following command:
setup.exe /UPGRADESP SQLRUN INSTANCENAME=your MSDE instance BLANKSAPWD=1

After You Update to SP3

After you upgrading SQL Server to SP3, BizTalk Server may not be able to connect with SQL Server. You may receive one of the following error messages in the event log:

Event Source: BizTalk Server
Event Category: Document Processing
Event ID: 324

Description: An error occurred in BizTalk Server.

Details:
------------------------------
[0x80040e4d] BizTalk Server failed to initialize a connection to database: "InterchangeBTM" on server: "SQLSERVER". :'Login failed for user 'DOMAIN\USERNAME'.' 0x80040e4d

[0x150a] The configuration cache data from the database could not be loaded.

[0x1509] The administration cache cannot be created.

[0x0111] The Queue Scheduler for the service could not be created.

-or-

Event Source: BizTalk Server
Event Category: Document Processing
Event ID: 324

An error occurred in BizTalk Server.

Details:
------------------------------
[0x80004005] BizTalk Server failed to initialize a connection to database: "InterchangeBTM" on server: "SQLSERVER". :'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.'

[0x150a] The configuration cache data from the database could not be loaded.

[0x1509] The administration cache cannot be created.

[0x0111] The Queue Scheduler for the service could not be created.

To resolve these error messages, you may have to restart the computer that is running BizTalk Server. If you are using BizTalk Server 2000, you may also have to re-create the SQL Server logon that BizTalk Server uses to connect to SQL Server.