April 21, 2004 at 9:12 am
I have two servers SERVA AND SERVB
When i insert/update(once in a day) on SERVA that should be done on SERVB also,
I have created trigger on SERVA table to do this, but when insert/update the data on SERVA getting the following error
[OLE/DB provider returned message; New transaction cannot enlist in the specified transaction coordinator.]
If disable the trigget just working fine.
I have checked the DTC it is up and running.
Thanks
April 21, 2004 at 9:15 am
Are you running Windows 2003?
April 21, 2004 at 10:03 am
it's windows 2000, sp 4 and sql 2k sp 3
April 21, 2004 at 10:08 am
Any firewall between the two servers?
April 21, 2004 at 10:14 am
yes, there is a firewall
April 21, 2004 at 10:16 am
Check out the following link to a Q article for troubleshooting DTC problems through a firewall
http://support.microsoft.com/default.aspx?scid=kb;EN-US;306843
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply