|
Home > Archive > BizTalk Server Applications Integration > May 2005 > DTC in SQL adapter
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 in SQL adapter
|
|
| Matt V 2005-04-26, 8:46 pm |
| I have a solution using the sql adpater of biztalk which
executes a sproc.
This sproc then executes another sproc on another server
inside a transaction.
I have turned on DTC inside win components and in
Component services.
I also done that reg fix in kb article
(http://support.microsoft.com/?kbid=839187). Yet it
still gives an error.
Help!!
ERROR:
The adapter "SQL" raised an error message.
Details "HRESULT="0x80040e14" Description="Distributed
transaction completed. Either enlist this session in a
new transaction or the NULL transaction."
HRESULT="0x80040e14" Description="[OLE/DB provider
returned message: New transaction cannot enlist in the
specified transaction coordinator. ]"
HRESULT="0x80040e14" Description="OLE DB error trace
[OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a]."
HRESULT="0x80040e14" Description="The operation could not
be performed because the OLE DB provider 'SQLOLEDB' was
unable to begin a distributed transaction."
| |
| Jorge Rocha Gualtieri 2005-04-29, 6:06 pm |
| Matt,
It's appear that you are not inside a DTC context. Both SQL servers are in
same domain? both have DTC network access enabled? if you execute this sp on
query analyzer using "BEGIN DISTRIBUTED TRAN" works?
--
Jorge Rocha Gualtieri
"Matt V" wrote:
> I have a solution using the sql adpater of biztalk which
> executes a sproc.
> This sproc then executes another sproc on another server
> inside a transaction.
> I have turned on DTC inside win components and in
> Component services.
> I also done that reg fix in kb article
> (http://support.microsoft.com/?kbid=839187). Yet it
> still gives an error.
> Help!!
>
> ERROR:
> The adapter "SQL" raised an error message.
> Details "HRESULT="0x80040e14" Description="Distributed
> transaction completed. Either enlist this session in a
> new transaction or the NULL transaction."
> HRESULT="0x80040e14" Description="[OLE/DB provider
> returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]"
> HRESULT="0x80040e14" Description="OLE DB error trace
> [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]."
> HRESULT="0x80040e14" Description="The operation could not
> be performed because the OLE DB provider 'SQLOLEDB' was
> unable to begin a distributed transaction."
>
>
| |
| Niklas E 2005-05-08, 5:48 pm |
| If you change to TurnOffRpcSecurity and install Windows 2003 SP1, there is a
bug in Windows 2003 SP1, which alters that setting (setting it to 0 instead
of 1) so then you have to reapply that fix.
Try the dtctester tool from Microsoft. It should give you some more
information. There is also a less-useful tool called dtcping, which may help
you as well.
You have to open ports in the firewall for DTC to work successfully if you
have a firewall. You can set the port range for DTC(RPC) in Component
services. I have mine set to 5000-5199, which seems to work fine.
You have to apply these fixes, settings etc on all servers involved as well,
not only the BizTalk server.
Best regards
Niklas Engfelt
"Matt V" <anonymous@discussions.microsoft.com> wrote in message
news:021901c54ac6$3b188590$a401280a@phx.gbl...
>I have a solution using the sql adpater of biztalk which
> executes a sproc.
> This sproc then executes another sproc on another server
> inside a transaction.
> I have turned on DTC inside win components and in
> Component services.
> I also done that reg fix in kb article
> (http://support.microsoft.com/?kbid=839187). Yet it
> still gives an error.
> Help!!
>
> ERROR:
> The adapter "SQL" raised an error message.
> Details "HRESULT="0x80040e14" Description="Distributed
> transaction completed. Either enlist this session in a
> new transaction or the NULL transaction."
> HRESULT="0x80040e14" Description="[OLE/DB provider
> returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]"
> HRESULT="0x80040e14" Description="OLE DB error trace
> [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]."
> HRESULT="0x80040e14" Description="The operation could not
> be performed because the OLE DB provider 'SQLOLEDB' was
> unable to begin a distributed transaction."
>
| |
| Imran Shabbir (Mobilink Pakistan) 2005-05-26, 5:55 pm |
| Hi Matt here is your solution
You have to turn off RPC security, follow these steps:
Start Registry Editor (Regedt32.exe).
Locate the following key in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
DTC
On the Edit menu, click Add Value, and then add the following registry value:
Value Name : TurnOffRpcSecurity
Data Type : REG_DWORD
Value : 1
Good Luck
"Matt V" wrote:
> I have a solution using the sql adpater of biztalk which
> executes a sproc.
> This sproc then executes another sproc on another server
> inside a transaction.
> I have turned on DTC inside win components and in
> Component services.
> I also done that reg fix in kb article
> (http://support.microsoft.com/?kbid=839187). Yet it
> still gives an error.
> Help!!
>
> ERROR:
> The adapter "SQL" raised an error message.
> Details "HRESULT="0x80040e14" Description="Distributed
> transaction completed. Either enlist this session in a
> new transaction or the NULL transaction."
> HRESULT="0x80040e14" Description="[OLE/DB provider
> returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]"
> HRESULT="0x80040e14" Description="OLE DB error trace
> [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a]."
> HRESULT="0x80040e14" Description="The operation could not
> be performed because the OLE DB provider 'SQLOLEDB' was
> unable to begin a distributed transaction."
>
>
|
|
|
|
|