Error: SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cursor stateThe reason in this case is that the CID GUID is not unique on the servers.
Run regedit and browse to HKEY_CLASSES_ROOT\CID\ and find the GUID where Description is set to MSDTC (it is one of the four). The GUID should be exactly the same on the other server.
Open a command prompt as administrator and run the command
msdtc -uninstallfollowed by
msdtc -installVerify that the DTC coordinator has started up and check the CID values in the registry. When running MSDTCTester again it should show a successful result:
This error will be caught by the BizTalk MessageBox Viewer. It will show an error of
is duplicated on servers and - Check if < server1> and are not cluster nodes as CID must be unique on non-clustered servers!