Sql Adapter MSDTC Problem

I am getting this error:
New transaction cannot enlist in the specified transaction coordinator
When I am trying to generate a schema from a database existed in a
machine the OS of it is Windows 2003 SP1, and the O.S. of the
machine that am trying to generating the schemas from is Windows XP SP2 , so
I had tried the following solutions and nothing happen

  1. I had manipulate the communication settings on both of the BizTalk machine and the SQL machine using the instructions this article :
    i.
    http://msdn2.microsoft.com/en-us/library/ms679479.aspx
  2. In addition, I had added MSDTC 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.

  3. I had turned off RPC security , using the following steps :
    1. Start Registry Editor (Regedt32.exe).
    2. Locate the following key in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC
    3. On the Edit menu, click Add Value, and then add the following registry value:

Finally, AfterI had researched for a long time within the blogs , I found that you should Enable NetBIOS on your network adapter taking the following steps:

  1. Start => Control panel => Network Connections
  2. Open Properties for the you network connection
  3. TCP/IP Properties
  4. Advanced and select WINS Tab

  5. Ensure that the "Enable NetBIOS over TCP/IP" is selected



0 Response to "Sql Adapter MSDTC Problem"