SQL Server Performance Forum – Threads Archive
MSDTC on server ‘servername’ is unavailable.I’m getting the following error message when testing Transaction replication with immediate update "MSDTC on server ‘servername’ is unavailable." MSDTC on both the publisher and the subscriber is running under the same account as SQL Server and SQL Agent. This account has network access as well as network admin privilege. Does anyone know why this is happening? Any information would be greatly appreciated. Regards
After the Distributed Transaction Coordinator (DTC) proxy has initialized itself to talk to a specific DTC service, the only way to make any changes is to stop the process. When the SQL Server-based service initializes the DTC proxy, the SQL Server-based service starts and then connects to the local DTC service. Check whether DTC service is installed and if so start the server to set it to Auto-start. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Search for MSDTC on the forum, there are many posts about it. For MSDTC to work one thing that has to function is name resolution between all servers. If you are using clusters it’s not only the virtual names but also the node names. A simple test is to try and ping all involved servers by name between eachother. Also if you are running Windows 2003 MSDTC has to be enabled for network access.