asked on

URGENT! Linked server 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391)

Hi, I have set a linked server sql2k sp3 in another sql2k sp3.. when i try to run a job I'm geting the following error:

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a]. [SQLSTATE 01000] (Error 7300). The step failed.

Any clues?!
Searched technet..msdn etc.. it has something with the provider reg settings.. can't nail that bug down..

ASKER CERTIFIED SOLUTION

Lowfatspread

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Michel Sakr

ASKER

.. I fixed it.. sorry the servers were win2k3 and it was a problem in the msdtc network connectivity not being checked.. I was supporting the issue on the phone.. :p

Michel Sakr

ASKER

For reference

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

Michel Sakr

ASKER

I should award myself the points.. :o)

rohitma

im getting the same problem, my linker serve are win2K
unfortunately there is no checkbox for network connectivity

mazzarelloa

I was have the same problem with this code:

INSERT INTO <db_name1>.dbo.<table_name1> (<column_name)
SELECT <column_name> FROM <linked_server_name>.<db_name2>.dbo.<table_name2>

I was resolved it in this case:

SELECT <column_name> INTO #tmp
FROM <linked_server_name>.<db_name2>.dbo.<table_name2>

INSERT INTO <db_name1>.dbo.<table_name1> (<column_name)
SELECT <column_name> FROM #tmp

cschmid

I have the same problem, anybody have a solution?

cgcc

I have solved this problem too. I used these instructions

http://support.microsoft.com/default.aspx?scid=kb;en-us;816701
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

and becouse my SQLServers are in different untrusted domains, I had to select "No Authentication required" in Security Configuration.
Maybe there is another solution with authentication, but I have no more time to find.

bstiles

I have the same problem in 2003 Server Clustered and I have followed the articles to a "T" with no resolutions I still get the same error:
error: (#-2147217900) The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

bstiles

By the way I am running 2003 clustered with 2 nodes and SQL 2000 sp4 using linked server