|
Home > Archive > BizTalk Server Applications Integration > August 2004 > SQLAdapter Errors - 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 |
SQLAdapter Errors - Remote SQL Server
|
|
|
| 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. | |
| Jeff Lynch 2004-08-10, 8:48 pm |
| Take a look at this KB article. You may have a related DTC / RPC security
issue in Windows Server 2003.
http://support.microsoft.com/defaul...roduct=bizt2002
--
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
>
| |
|
| Thanks Jeff!
That fix worked great. If anyone else if having this problem, please note that you only need to do this on the machine that is receiving the RPC, not the 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.
http://support.microsoft.com/defaul...roduct=bizt2002
--
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
>
|
|
|
|
|