|
Home > Archive > BizTalk Server General > November 2004 > storing data on a remote database
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 |
storing data on a remote database
|
|
|
| When we are sending data to a database not on the same machine as Biztalk,
we get this error:
"New transaction cannot enlist in the specified transaction coordinator. "
Where do I go to resolve this issue, as no data is being inserted to the
table. This map/project ran fine on my developement machine, but now we are
moving it to the test box, and sending it to a remote database.
Thanks,
Eric
| |
| Balaji Thiagarajan 2004-11-22, 5:48 pm |
| Follow the thread titled "msdtc problem with win xp sp2, ql adapter and
different sql server then local" appeared on 11/15/2004 in this forum.
--
Balaji Thiagarajan
MCP (BizTalk)
http://biztalkbits.blogspot.com
--
"Eric" <ericstott.dnsme@hotmail.com> wrote in message
news:Okaj2DO0EHA.3244@TK2MSFTNGP10.phx.gbl...
> When we are sending data to a database not on the same machine as Biztalk,
> we get this error:
>
> "New transaction cannot enlist in the specified transaction coordinator. "
>
> Where do I go to resolve this issue, as no data is being inserted to the
> table. This map/project ran fine on my developement machine, but now we
are
> moving it to the test box, and sending it to a remote database.
>
> Thanks,
> Eric
>
>
| |
| Alan Smith 2004-11-23, 2:47 am |
| Hi Eric,
I have run into a similar problem. By default, Server 2003 dissabled network
DTC access. To enable it manually, try the following:
In Add Remove Programs/Windows Components, select Application Server, and
check Enable COM+access, and Enable Network DTC access.
Select Component Services from the Admin Tool, select My Computer,
properties MSDTC, then Security Configuration. Check Network DTC Access,
Netwrk Administration, Network Transactions, and Network Clients.
I think you need to have these settings on both boxes, and you may need to
reboot after changing the settings. I'm not sure if these are the optimal
settings but they seem to work for me. I have seen several different
configurtions recommended in different BizTalk docs and whitepapers, I'd love
to know the correct settings...
Hope this helps,
Alan
"Eric" wrote:
> When we are sending data to a database not on the same machine as Biztalk,
> we get this error:
>
> "New transaction cannot enlist in the specified transaction coordinator. "
>
> Where do I go to resolve this issue, as no data is being inserted to the
> table. This map/project ran fine on my developement machine, but now we are
> moving it to the test box, and sending it to a remote database.
>
> Thanks,
> Eric
>
>
>
| |
| Devdutt Patnaik 2004-11-23, 5:56 pm |
| We're using the exact same settings that Alan suggests on all boxes in the
configuration and it works for us. Another small thing that you need to
verify is the possibility that there's a firewall between your BizTalk box
and your SQL server box (improbable, but its happened to me), in which case
you'll need to re-configure your firewall.
Regards
Dev
"Alan Smith" <AlanSmith@discussions.microsoft.com> wrote in message
news:49B19EB1-9F2A-4D04-9F95-7F7C5380C1E6@microsoft.com...
> Hi Eric,
>
> I have run into a similar problem. By default, Server 2003 dissabled
network
> DTC access. To enable it manually, try the following:
>
> In Add Remove Programs/Windows Components, select Application Server, and
> check Enable COM+access, and Enable Network DTC access.
>
> Select Component Services from the Admin Tool, select My Computer,
> properties MSDTC, then Security Configuration. Check Network DTC Access,
> Netwrk Administration, Network Transactions, and Network Clients.
>
> I think you need to have these settings on both boxes, and you may need to
> reboot after changing the settings. I'm not sure if these are the optimal
> settings but they seem to work for me. I have seen several different
> configurtions recommended in different BizTalk docs and whitepapers, I'd
love[vbcol=seagreen]
> to know the correct settings...
>
> Hope this helps,
>
> Alan
>
>
> "Eric" wrote:
>
Biztalk,[vbcol=seagreen]
"[vbcol=seagreen]
are[vbcol=seagreen]
|
|
|
|
|