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:
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:
Install SP3 on SQL Server 2000
To install SQL Server 2000 SP3, visit the following Microsoft Web site:
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:
- 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.