You must install the SQL Server 2000 update that KB article 831950 describes to run BizTalk Server 2004 (838166)

SUMMARY

The Microsoft BizTalk Server 2004 Installation Guide indicates that you must have the Microsoft SQL Server 2000 update that Microsoft Knowledge Base (KB) article 831950 describes installed on any computer that has SQL Server 2000 installed and that houses your BizTalk Server databases.

MORE INFORMATION

The following table lists the packages for this SQL Server 2000 update that are available in the Microsoft Download Center. Click the link to download the package for your language.

Language	Package
English	SQL2000-KB810185-8.00.0878-ENU.exe
German	SQL2000-KB810185-8.00.0878-GER.exe
French	SQL2000-KB810185-8.00.0878-FRN.exe
Italian	SQL2000-KB810185-8.00.0878-ITA.exe
Spanish	SQL2000-KB810185-8.00.0878-ESN.exe
Japanese	SQL2000-KB810185-8.00.0878-JPN.exe
Korean	SQL2000-KB810185-8.00.0878-KOR.exe
Chinese (Simplified)	SQL2000-KB810185-8.00.0878-CHS.exe
Chinese (Traditional)	SQL2000-KB810185-8.00.0878-CHT.exe

For additional information about this SQL Server 2000 update, click the following article number to view the article in the Microsoft Knowledge Base:

831950 FIX: You receive error message 3456 when you try to apply a transaction log to a server

Note If you install this update on your computer that is running SQL Server after you have already installed the BizTalk Server 2004 databases, you must manually stop and then restart the Enterprise Single Sign-On Service and any running BizTalk Application Services on your BizTalk Server.