Msdtc will not connect after cloning a machine.
When running DTCTester the following error will appear:
Error: SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cursor state
To Correct this an uninstall and reinstall of MSDTC on the non sql server must be done to foce the creating of a new CID.
Open a command prompt as administrator and run the command
Warning: It does not give any return response when running this command. Run the DTCtester to make sure of connection.
Ensure you enable MSDTC and configure Network DTC Access in the Component Services administrative tool to enable the following minimum required settings:
Â· Allow Remote Clients
Â· Allow Inbound
Â· Allow Outbound
Â· Mutual Authentication Required
You must specify the same type of authentication for all Sentinel Agent Manager components in order for Windows servers to communicate with one another.