BizTalk Server General - New transaction cannot enlist in the specified transaction coordinator

Author

New transaction cannot enlist in the specified transaction coordinator

wask

2005-12-05, 5:55 pm

Hi

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 and
receive data from table in receive port on remote SQL server.

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

The SQL Server machine is running Windows 2000
BizTalk 2004 machine is running windows 2003 with Network DTC Access
turned on for Network Admin & Network Transactions.

Thanks for the help.

wask

wask

2005-12-05, 5:55 pm

Hi

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 and

receive data from table in receive port from remote SQL server.

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

The SQL Server machine is running on remote Windows 2000 with cluster
BizTalk 2004 machine is running windows 2003 with Network DTC Access
turned on for Network Admin & Network Transactions.

I checked some article it say For W2K the defalut DTC Security on port
(3372) is open
For W2K3 the defalut DTC security on the port is closed.

Should i open 3372 port to connect remote SQL Server.

Thanks for the help.

wask

Mike Koerner

2005-12-05, 5:55 pm

Hi,
I had a similar problem. Follow this kb
http://msdn.microsoft.com/library/d....asp?frame=true
Be sure to reboot the SQL server after the completion.

Good luck.

Mike

"wask" <venukancharla@gmail.com> wrote in message
news:1133811864.630536.51820@g49g2000cwa.googlegroups.com...
> Hi
>
> 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 and
> receive data from table in receive port on remote SQL server.
>
> The adapter "SQL" raised an error message. Details "New transaction
> cannot enlist in the specified transaction coordinator. ".
>
> The SQL Server machine is running Windows 2000
> BizTalk 2004 machine is running windows 2003 with Network DTC Access
> turned on for Network Admin & Network Transactions.
>
> Thanks for the help.
>
> wask
>

wask

2005-12-05, 5:55 pm

Mike

Thanks for help.

Every thing set according to kb
(http://msdn.microsoft.com/library/d...y/en-us/depl...

). But still i get same error.

thanks
wask

wask

2005-12-05, 5:55 pm

Mike

SQL Server is running on remote machine with windows 2000. My Biztalk
2004 server running on Windows 2003.

thanks
wask

Mike Koerner

2005-12-06, 5:54 pm

Hi,

Still doesn't work?
We've used the DTC Tester tool before on a different machine.
http://support.microsoft.com/defaul...kb;en-us;293799

Please post back if you get it to work.

Good luck again.
Mike

"wask" <venukancharla@gmail.com> wrote in message
news:1133818045.373077.15020@z14g2000cwz.googlegroups.com...
> Mike
>
> Thanks for help.
>
> Every thing set according to kb
> (http://msdn.microsoft.com/library/d...y/en-us/depl...
>
> ). But still i get same error.
>
> thanks
> wask
>