|
Home > Archive > BizTalk Server General > November 2004 > dtc error when saving to remote sql server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dtc error when saving to remote sql server
|
|
|
| Hi,
when i try to use sql adapter for biztalk 2002 to save patient info to a
remote sql server, i got error
"MS DTC is unable to comunicate wit hMS DTC on a remote system. No common
RPC protocol is supported between the two systems. Please ensure that one
or more of the following RPC protocols are common to both systems: TCP/IP,
SPX, or NetBEUI. Error Specifics:.\iomgrclt.cpp:203, CmdLine:
c:\WINNT\System32\msdtc.exe, Pid: 608"
Event ID: 4357
any idea about this?
thanks,
jj
| |
| Anthony Odole 2004-11-23, 2:47 am |
| JJ,
The first step to resolving this problem is to use DTCPing to test
connectivity between the two systems -- for this scenario, we will say
Server 1 and Server 2. . Start DTC on the server 2, then do a DTC ping from
server 1. Once connectivity is confirmed, you need to reverse the steps by
starting DTC ping on server 1 and then do a DTC ping from server 2. In most
cases, the DTC ping will work in one direction but not the other. If you are
using DNS to resolve names, make sure that both servers are registered with
DNS. If not, you can use host files by verifying that each server can be
reached from the other by adding the IP address of one system to the other
and vice-versa. Let me know if you need more detailed step by step
instructions.
Anthony
"jj" <jjcpa@rocketmail.com> wrote in message
news:1xaa71xyqgc02.11btuk7cqnhuq$.dlg@40tude.net...
> Hi,
>
> when i try to use sql adapter for biztalk 2002 to save patient info to a
> remote sql server, i got error
> "MS DTC is unable to comunicate wit hMS DTC on a remote system. No common
> RPC protocol is supported between the two systems. Please ensure that one
> or more of the following RPC protocols are common to both systems: TCP/IP,
> SPX, or NetBEUI. Error Specifics:.\iomgrclt.cpp:203, CmdLine:
> c:\WINNT\System32\msdtc.exe, Pid: 608"
>
> Event ID: 4357
>
> any idea about this?
>
> thanks,
>
> jj
| |
| Devdutt Patnaik 2004-11-23, 5:56 pm |
| 1)Goto Control Panel>Add Remove Programs>Add Remove Windows
Components>Application Server
There check the box labelled "Enable Network DTC Access"
Do this for all boxes in your installation, BizTalk Servers, SQL servers
et all.
2) Goto Control Panel>Administrative Tools>Component Services.
Expand "Component Services" and then expand "Computers".
Right-click on "My computer" click on "Properties".
Goto the MSDTC tab and click on the "Security Configuration" button.
Ensure that the "Network DTC Access", "Network Administration", "Network
Transaction" and "Network Clients" check boxes are checked.
Do this for all boxes in your installation, BizTalk Servers, SQL servers
et all.
If these steps donot solve ur problem then see if you have a firewall setup
between ur BizTalk Box and your sql server box.
HTH
Dev
http://devdutt10.blogspot.com
"jj" <jjcpa@rocketmail.com> wrote in message
news:1xaa71xyqgc02.11btuk7cqnhuq$.dlg@40tude.net...
> Hi,
>
> when i try to use sql adapter for biztalk 2002 to save patient info to a
> remote sql server, i got error
> "MS DTC is unable to comunicate wit hMS DTC on a remote system. No common
> RPC protocol is supported between the two systems. Please ensure that one
> or more of the following RPC protocols are common to both systems: TCP/IP,
> SPX, or NetBEUI. Error Specifics:.\iomgrclt.cpp:203, CmdLine:
> c:\WINNT\System32\msdtc.exe, Pid: 608"
>
> Event ID: 4357
>
> any idea about this?
>
> thanks,
>
> jj
|
|
|
|
|