I am getting the following error message in the Event Viewer when using an U
pdategram to insert into a table on a remote SQL Server Machine.

The adapter "SQL" raised an error message. Details "New transaction cannot e
nlist in the specified transaction coordinator.  ".

If I change my SQL send port to the local machine, I have no problems.

Any ideas?  The SQL Server machine is running Windows 2003 with Network DTC 
Access turned on for Network Admin & Network Transactions.

Thanks for the help.

[ Post a follow-up to this message ]

Take a look at this KB article. You may have a related DTC / RPC security
issue in Windows Server 2003.

[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;839187&Product=bizt2002[/u
rl]

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/


"DougW" <DougW.1aso93@mail.webservertalk.com> wrote in message
news:DougW.1aso93@mail.webservertalk.com...
>
> I am getting the following error message in the Event Viewer when using
> an Updategram to insert into a table on a remote SQL Server Machine.
>
> The adapter "SQL" raised an error message. Details "New transaction
> cannot enlist in the specified transaction coordinator.  ".
>
> If I change my SQL send port to the local machine, I have no problems.
>
> Any ideas?  The SQL Server machine is running Windows 2003 with Network
> DTC Access turned on for Network Admin & Network Transactions.
>
> Thanks for the help.
>
>
>
> --
> DougW
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message344532.html
>

[ Post a follow-up to this message ]

Thanks Jeff!

That fix worked great.  If anyone else if having this problem, please note t
hat you only need to do this on the machine that is receiving the RPC, not t
he sending machine.

Also, after adding the key, you must reboot the machine.

Thanks,
Doug

quote:
Originally posted by Jeff Lynch 
Take a look at this KB article. You may have a related DTC / RPC security
issue in Windows Server 2003.

[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;839187&Product=bizt2002[/u
rl]

--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/


"DougW" <DougW.1aso93@mail.webservertalk.com> wrote in message
news:DougW.1aso93@mail.webservertalk.com...
>
> I am getting the following error message in the Event Viewer when using
> an Updategram to insert into a table on a remote SQL Server Machine.
>
> The adapter "SQL" raised an error message. Details "New transaction
> cannot enlist in the specified transaction coordinator.  ".
>
> If I change my SQL send port to the local machine, I have no problems.
>
> Any ideas?  The SQL Server machine is running Windows 2003 with Network
> DTC Access turned on for Network Admin & Network Transactions.
>
> Thanks for the help.
>
>
>
> --
> DougW
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message344532.html
> 

[ Post a follow-up to this message ]