Unable to begin a distributed transaction

by

Found it, MSDTC on the remote server was a clone of the local server.

From the Windows Application Events Log:

Event Type: Error
Event Source: MSDTC
Event Category: CM
Event ID: 4101
Date: 9/19/2011
Time: 1:32:59 PM
User: N/A
Computer: ASITESTSERVER
Description:

The local MS DTC detected that
the MS DTC on ASICMSTEST has the same unique identity as the local MS
DTC. This means that the two MS DTC will not be able to communicate
with each other. This problem typically occurs if one of the systems
were cloned using unsupported cloning tools. MS DTC requires that the
systems be cloned using supported cloning tools such as SYSPREP.
Running ‘msdtc -uninstall’ and then ‘msdtc -install’ from the command
prompt will fix the problem. Note: Running ‘msdtc -uninstall’ will
result in the system losing all MS DTC configuration information.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Running

msdtc -uninstall
msdtc -install

and then stopping and restarting SQL Server service fixed it.

More Related Contents:

  1. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  2. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  3. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  4. Parameter Sniffing (or Spoofing) in SQL Server
  5. What are the main performance differences between varchar and nvarchar SQL Server data types?
  6. SQL Server String or binary data would be truncated
  7. Datatype for storing ip address in SQL Server
  8. How to change identity column values programmatically?
  9. best way to convert and validate a date string
  10. Why use the INCLUDE clause when creating an index?
  11. Why is it considered bad practice to use cursors in SQL Server?
  12. CAST and IsNumeric
  13. SQL Server pivot vs. multiple join
  14. How do you specify a different port number in SQL Management Studio?
  15. How do I enable MSDTC on SQL Server?
  16. SQL Server GUID sort algorithm. Why?
  17. WHERE clause on SQL Server “Text” data type
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Parse XML in SQL Server
  20. SQL server schema and default schema
  21. SQL Server ON DELETE Trigger
  22. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  23. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  24. FOR XML PATH(”): Escaping “special” characters
  25. How to store directory / hierarchy / tree structure in the database?
  26. INFORMATION_SCHEMA vs sysobjects
  27. Why is casting from float to varchar being rounded in SQL Server?
  28. Does query plan optimizer works well with joined/filtered table-valued functions?
  29. What are row, page and table locks? And when they are acquired?
  30. Cross Domain SQL Server Logins Using Windows Authentication

Leave a Comment