Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
While configuring the Biztalk server2004 I got below error.please let me know how to solve this error.
C#
Failed to deploy BizTalk system assembly "C:\Program 
Files\Microsoft BizTalk Server 
2004\Microsoft.BizTalk.GlobalPropertySchemas.dll".
[Microsoft.BizTalk.Deployment.DeploymentException] 
[System.Data.SqlClient.SqlException] Failed to load msxmlsql.dll.
[System.Data.SqlClient.SqlException] Failed to load msxmlsql.dll.

[Microsoft.BizTalk.Deployment.DeploymentException] 
[System.Data.SqlClient.SqlException] Failed to load msxmlsql.dll.
[System.Data.SqlClient.SqlException] Failed to load msxmlsql.dll.
Posted
Updated 23-Dec-11 1:53am
v2

1 solution

This may occur when applying a BizTalk configuration file in silent or interactive mode. The full error (from the log in silent) is:

Failed to deploy system assembly "C:\Program Files\Microsoft BizTalk Server 2004\Microsoft.BizTalk.GlobalPropertySchemas.dll". The rest of the error message is informative as well; giving you a hint on where to go:

“The network clients for the Distributed Transaction Coordinator (DTC) Network must have the remote clients/transactions option enabled. The partner transaction manager has disabled its support for remote/network transactions.“

This is a DTC issue; in this case, DTC isn't properly configured on a remote SQL Server. Help and troubleshooting will give you a text string containing “You must enable network clients DTC access before configuring BizTalk Server“. Check your installation steps and ensure you:

On the SQL Server, navigate to Component Services, Computers.
Right-click the My Computer icon and select Properties, MSDTC.
Click Security Configuration, Network DTC Access.
Ensure Network Clients is selected.
To save time, perform/confirm these steps on the BizTalk server as well.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900