Users put forward requirements for our project to process the data of their original projects at the same time. The databases of the new project and the original project are both sqlserver2005, which are on different servers. The test environment sqlserver2005 is linked to the server sqlserver2012. I planned to establish a linked server on the new project database to operate the database on the old server. However, during the actual operation of the project, I found that an error occurred when using SQL statements from the project to operate the old database through the linked server. I verified that the SQL statements were executed in the new database. any problem. Baidu tried many methods to start the MSDTC service, turn off the firewall, add set xact_abort ON, set it through management tools, directly use JDBC to access the database, etc., but none of them solved the problem.
Error message: