Open the MSDTC method (diagram), open the msdtc method Diagram

Open the MSDTC method (diagram), open the msdtc method Diagram

I recently used it when I was working on a project.. net. transactions (distributed transaction), after the project development is complete, encountered the msdtc problem during the arrangement. After reading a lot of relevant information, this problem was solved, the general problem is that the database cannot be accessed because distributed transactions are used. The specific error message is unclear .. You can also find many solutions on the Internet, but start the service and modify the options in the component service. However, when the web server and the database server are not on the same machine, an error is returned .. The following is my solution ..

1. Open the Distributed Transaction Coordinator service in the service.

2. modify some options in the component service.
Click Start> Administrative Tools> component services ";
Expand "component service"> "computer"> "my computer"> "Distributed Transaction Coordinator", right-click "Local DTC", select "properties", and click set, after setting, click OK.

At this time, the local server can be used normally, but when the web server and the database server are not on the same machine, an error will still be reported, in this case, you need to open a port and an application on the database server.

3. Enable Firewall settings and add inbound/outbound rules
Port 135
The application is C: \ Windows \ System32 \ msdtc.exe

It should be okay now ..