SQL Server Performance

MSDTC on server 'servername' is unavailable.

Discussion in 'Performance Tuning for SQL Server Replication' started by magictech, Mar 21, 2005.

  1. magictech New Member

    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
  2. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Argyle New Member

    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.

Share This Page