Hi There,
Thank you for asking this question on the Microsoft Q&A Platform.
As error clearly indicates, you have an issue in connectivity, please check the below points,
- Do you have BizTalk and SQL on same server or different servers?
- If you have different servers then please check the connectivity between both the servers.
- Please check the MSDTC configuration for both the servers, refer:
https://learn.microsoft.com/en-us/biztalk/core/troubleshooting-problems-with-msdtc?redirectedfrom=MSDN
https://learn.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sql/configure-msdtc-on-sql-server-and-adapter-client
Regards,
Kamlesh Kumar
BizTalk Techie
If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.