we have following error in windows log when we try to start 64-bit BizTalk host instance.
(BizTalk Server 2009, SQL Server 2008, Windows Server 2008 R2)
Faulting application name: BTSNTSvc64.exe, version: 3.8.368.0, time stamp: 0x49b1f793
Faulting module name: KERNELBASE.dll, version: 6.1.7600.16385, time stamp: 0x4a5bdfe0
Exception code: 0xe0434f4d
Fault offset: 0x000000000000aa7d
Faulting process id: 0x1d08
Faulting application start time: 0x01cb1dca422e30ab
Faulting application path: E:\Program Files (x86)\Microsoft BizTalk Server 2009\BTSNTSvc64.exe
Faulting module path: C:\Windows\system32\KERNELBASE.dll
Report Id: 803103c0-89bd-11df-9a1c-e41f131a4842
Service request: Start
BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication
Additional error information:
Error code: 0xc0c0153a
Error source: BizTalk Server 2009
Error description: A BizTalk subservice has failed while executing a service request.
Subservice: Tracking
Service request: Start
Additional error information:
Error code: 0x80131534
Error source: System.Data
Error description: The type initializer for ‘System.Data.SqlClient.SqlConnection’ threw an exception.
After lots of troubleshooting, the apparent reason for this error is missing SP1 installation for SQL Server 2008.
SQL Server 2008 have compatibility issues with windows server 2008 R2 and SQL Setup points this out during the installation
Usman's blog 