Microsoft KB Archive/814086

= How to Install SQL Server 2000 Security Patch MS02-061 or SP3 with BizTalk Server =

Article ID: 814086

Article Last Modified on 11/24/2006

-

APPLIES TO


 * Microsoft BizTalk Server 2002 Standard Edition
 * Microsoft BizTalk Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Service Pack 1
 * Microsoft SQL Server 2000 Service Pack 2

-



SUMMARY
This article describes how to install updates to SQL Server 2000 to help protect against the Slammer worm when you are using BizTalk Server 2000 or BizTalk Server 2002.



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/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/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/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en

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/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf-acace5369fa3&DisplayLang=en

 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= BLANKSAPWD=1

</li></ol>

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: &quot;InterchangeBTM&quot; on server: &quot;SQLSERVER&quot;. :'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: &quot;InterchangeBTM&quot; on server: &quot;SQLSERVER&quot;. :'[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.

Keywords: kbinfo kbhowto KB814086

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.