An error occured while...

[Guest]

Hi,
I have an asp.net app that is using a sql-database localted on a different
machine. These two machines are in the same network and there is no firewalls
in between. The app is using Serviced Components and are installed in the
Component Service.

When I try to update the database this error occures:
"An error occured while enlisting in a distributed transaction".

What is wrong and how can I fix this.

Thanks
Julia

 

[Scott Allen]

Hi,
I have an asp.net app that is using a sql-database localted on a different
machine. These two machines are in the same network and there is no firewalls
in between. The app is using Serviced Components and are installed in the
Component Service.

When I try to update the database this error occures:
"An error occured while enlisting in a distributed transaction".

What is wrong and how can I fix this.

See if MSDTC is running.

Administrative Tools -> Services -> Distributed Transaction
Coordinator.

I believe it will need to be running on the database server, and on
the server with the serviced component.

 

[Guest]

Hi,
Yes, it is running by the LocalSystem.

Julia

 

[Scott Allen]

Hi,
Yes, it is running by the LocalSystem.

Ugh, well, DTC can be finicky with network settings, name resolution
and such. Here are two documents with troubleshooting tips.

http://support.microsoft.com/kb/191168/EN-US/
http://support.microsoft.com/default.aspx?scid=kb;en-us;293799

I'd start with the ping test in the first article to make sure both
computers can be reached by name.