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
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
- 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 - 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. - 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:
- Start => Control panel => Network Connections
- Open Properties for the you network connection
- TCP/IP Properties
- Advanced and select WINS Tab
- Ensure that the "Enable NetBIOS over TCP/IP" is selected
0 Response to "Sql Adapter MSDTC Problem"
Post a Comment