February 24, 2009 at 2:54 pm
Hello,
I am having a strange problem trying to do a distributed transaction from a Clustered Server(Server A) to a non-Clustered Server(Server B). I am getting the common "Was unable to begin a distributed transaction" error when trying to execute a stored procedure through a linked server. The strange thing is that I can execute the exact same command successfully from a non-Clustered server to Server B. What is also strange is I can execute a distributed transaction from any server back to Server A.
We have 3 clustered servers in our shop. I am unable to execute the distributed transaction from any of them to Server B successfully. However, I have tried executing the statement on 3 of our non-clustered servers to Server B and it works fine. That rules out any problems with the way MSDTC is set up on Server B.
I could understand if MSDTC and the Cluster resource were set up incorrectly on Server A, but I am able to run a distributed transaction TO that server but not FROM it. In fact, not able to run distributed transactions from any of our Clustered Servers.
Any Ideas? Thanks.
February 24, 2009 at 9:06 pm
It is generally better to write code that may not use MSDTC but here are two how to with MSDTC and cluster from Microsoft.
http://support.microsoft.com/kb/254321
http://blogs.msdn.com/sqlblog/archive/2006/10/06/MSDTC-and-SQL-Server-on-a-cluster.aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply