Installation - SQL Server 2000

What is it?

Microsoft SQL Server 2000 is an enterprise-class relational database server capable of efficiently processing high volumes of critical data.

How does it affect my BizTalk Server installation?

The BizTalk Server 2004 engine provides the capability to specify a business process and a mechanism for communicating between applications the business process uses. The BizTalk Server 2004 core engine uses SQL Server 2000 as the main repository for this communication mechanism. SQL Server 2000 is a required piece of the overall architecture.

When you install and configure BizTalk Server 2004, the following SQL Server databases are created:

• BAM Primary Import database: default database name BAMPrimaryImport
• Star Schema database: default database name BAMStarSchema
• HWS Administration database: default database name BizTalkHwsDb
• BizTalk Tracking database: default database name BizTalkDTADb
• Configuration database: default database name BizTalkMgmtDb
• BizTalk MessageBox database: default database name BizTalkMsgBoxDb
• Rule Engine database: default database name BizTalkRuleEngineDb
• Trading Partner Management database: default database name TPM
• Enterprise Single Sign-On database: default database name SSODB
• BAM Analysis database: default database name BAMAnalysis
• Tracking Analysis Server database: default database name BizTalkAnalysisDb
• BizTalk Base EDI database: default database name BizTalkEDIDb

On a single-server installation, the following Windows accounts are created locally when you install and configure BizTalk Server 2004. Items denoted with an asterisk (*) are added as SQL Server accounts:

• BizTalk Application Users *
• BizTalk Server Administrators *
• BizTalk Host Users
• BizTalk Isolated Host Users *
• BizTalk Base EDI Users
• BizTalk BAS Web Services Group *
• BizTalk BAS Users
• BizTalk BAS Managers
• BizTalk BAS Administrators
• SSO Administrators *
• SSO Affiliate Administrators
• EDI Subsystem Users *

The following SQL Server jobs are also created:

• Backup BizTalk Server
• CleanupBTFExpiredEntriesJob_BizTalkMgmtDb
• MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb
• MessageBox_Message_Cleanup_BizTalkMsgBoxDb
• MessageBox_Parts_Cleanup_BizTalkMsgBoxDb
• PurgeSubscriptionsJob_BizTalkMsgBoxDb
• TrackedMessages_Copy_BizTalkMsgBoxDb
• TrackingSpool_Cleanup_BizTalkMsgBoxDb

Source: Luke Nyswonger MSDN Blog