SQL Server Performance Forum – Threads Archive

Distributed Transactions

I am trying to run a transaction that across two servers DTC is running and the servers are linked to one another still I get this message when I run the sp. It there something I must check before I can use Distributed Transactions? Server: Msg 7391, Level 16, State 1, Procedure pa_FinFacContabiliza_NV, Line 134
The operation could not be performed because the OLE DB provider ‘SQLOLEDB’ was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider ‘SQLOLEDB’ ITransactionJoin::JoinTransaction returned 0x8004d00a].
Cheers!

Duplicate post.
The other one was deleted.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

Cejar: Check: http://support.microsoft.com/support/kb/articles/q295/0/86.asp Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

Verify that the OLE DB provider specified supports distributed transactions. If the provider does not support distributed transactions, rewrite the data modification statement not to use distributed transactions. Check whether the RPC and RPC out is enabled on the linked server.
Make sure remote access is enabled on both servers and RPC services are running. Also ensure @@SERVERNAME value is not nULL. 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.

You can verify this by checking the distributed transaction coordinator service in the services manager on each computer. Here are a couple of other ways to check the status of the MSDTC service. Using component services on Win2K, drill down to the appropriate computer, right-click it, choose properties, and then select the MSDTC tab of the properties dialog. Using SQL Server enterprise manager, you can check the status of the distributed transaction coordinator service node under the support services folder. Or
You can connect to any instance of SQL Server with Query Analyzer and execute this command:
begin distributed tran
If its successful then it accepts. (BTW check your net settings seems double postings occured, which I’ve deleted)
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.

Thanks I will look into this. Cheers!

]]>