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: 
曾经蜡笔没有小新2017-05-17 10:09:11
Have you compared the similarities and differences of the Service Pack and all KB of the two servers?
给我你的怀抱2017-05-17 10:09:11
Currently we have found a compromise, adding a public method to use JDBC to operate the database on the old server, but it is not convenient to maintain. I hope someone can give the correct solution.
