SQL Server Performance Forum – Threads Archive

Fatal Error

Hi all ,
i’m facing a very serious error
———————————-
Server: Msg 7391, Level 16, State 1, Line 1
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].
———————————-
while running a stored procedure .THrough sp i’m accessing a remote server
which is linked to my current server. i’m not able to resolve the issue. Pls Help..
Thanks Atul A Sathe

Is this the only stored procedure having issues? Have you tried running straight commands in Query Analyzer between the two servers to simulate the issue? Is DTC enabled for the servers? Are these Windows 2003 servers? If so, do you have SP1? When did SP1 get installed? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

I have the same problem… I have 6 SQL linked servers, but only 4 of them works fine and when i’m trying to pass one of the other two I get this error. Can’t resolve this problem neither. 2derrickleggett I’ve tried to call my stor procedure in Query Analyzer, but there is no positive results <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> How can I find out if I have DTC enabled? I have Windows XP (SP2). This string (in my stor proc) is cause of error: insert into [#growthTempDBs] exec ServerGrowthGetDBSizes @ServerName = ‘server.name' when i’m running exec ServerGrowthGetDBSizes @ServerName = ‘server.name' in Query Analyzer it works properly. This is weird to me. Please help.

Under Add/Remove programs go into the Windows Components and under "Application Server" ensure that Network DTC access is enabled.

KBAs fyi:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306212&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;839279&Product=sql2k Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>