|
U3 -> RE: Error while creating SQL Adapter (15 January 2008)
|
Adnan-
This error is related to MSDTC ( Microsoft Data Tranasaction Coordinator), check the following steps to solve this issue :
1) you should manipulate the communication settings on both of the BizTalk machine and the SQL machine using the instructions this article :
http://msdn2.microsoft.com/en-us/library/ms679479.aspx
2) In addition, you should add MSDTC program and his port into the exception list in the Windows Firewall settings. using the following steps:
1. In Control Panel, open Windows Firewall.
2. Click the Exceptions tab, and then click Add Program.
3. Click Browse, and then add c:\windows\system32\msdtc.exe.
4. In Programs and Services, select the Msdtc.exe check box, and then click OK.
5. Click the Exceptions tab, and then click Add Port.
6. Add 135 as a port number and choose TCP
for more information , please check the following articles:
• http://msdn2.microsoft.com/en-us/library/ms686976.aspx
• http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306843
P.S : DON'T Forget to restart both of the machines , "the Server and the Client"
|
|
|
|
