Problem
Configuration fails with errors similar to the following when attempting to configure the Enterprise Single Sign-On (SSO) component:
An error occurred while attempting to access the SSO database.
Function: FieldInfoCreate
or
Failed to enable the Single Sign-On (SSO) Service (error code 0X800706BA)
Cause
If BizTalk Server and SQL Server are installed on different computers, then the configuration operations are performed under the context of a Microsoft Distributed Transaction Coordinator (MSDTC) transaction and MSDTC functionality must be available over the network between these computers. If MSDTC functionality is not available over the network between the computers running BizTalk Server and SQL Server, then this error can occur.
Resolution
Follow the steps in Troubleshooting Problems with MSDTC (http://go.microsoft.com/fwlink/?LinkId=72203) to ensure MSDTC functionality over the network between the computers running BizTalk Server and SQL Server.