Msdtc settings windows xp

Therefore this user right will not need to be changed unless the default setting has been modified. If the No Authentication Required configuration option is enabled then the Access this computer from the network user right does not apply to the client s computer account. Let me simplify the question. The content you requested has been removed. Ask a question. Quick access. This article contains information about how to modify the registry.

Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, see: Windows registry information for advanced users.

To do this, click Start , and then click Run Type dcomcnfg. If a password is needed, enter a blank password. If you change the account to an account other than the NetworkService account, the distributed transaction fails. The transaction fails because the MSDTC service cannot do mutual authentication together with other parties that are involved in the transaction.

I probably need to check some more settings on the server, but I can't see any that I've missed other than figuring out the right authentication to choose in the MSTDC settings on the DB server in dcomcnfg, firewall, etc. Hi, I have wasted half a day's work trying to understand the origin of this problem. Since this forum post ranks pretty high on a googe search for the search string " Distributed transaction error", I decided to post here what's helped me solve this problem:.

In case the URL above will become invalid in the future, this is the process that was required to solve my issue:. Reboot 5. Go to the command line and run: net start msdtc 8. Go to services. The content you requested has been removed. Then go to the Distributed Transaction Coordinator and look at the service. You can see msdtc settings in below screenshot. Configure Local DTC as follows. It will not be very safe to open Allow Remote Administration.

There are special msdtc firewall ports that it uses. You can find a list of these ports on the link below.