July 17, 2007 at 8:34 am
Hi,
I am running a stored prcedure in an SQL Server 2000 database which connects to an SQL Server 2005 database. The SP selects from the 2005 db and inserts into the 2000 db, and I am getting 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)
Following the advise in this article http://msdn2.microsoft.com/en-us/library/ms131002.aspx I have installed SQL Native client on the SQL Server 2000 box but it's still not working.
The table being inserted into does not have any triggers, I can setup a linked server to another 2000 box and perform the command fine.
When I look at the Transaction Statistics option in the Distributed Transactions folder within Component Services the page shows 6 Aborted attempts (which is the number of times I've tried to run the SP).
There is nothing in the SQL Error Logs, nothing in the Event Viewer, the account running the linked server between the 2000 and 2005 box exists on both servers and has sysAdmin rights.
The DTC is running as is the RPC. The only difference I can see is that SQL Server and the SQL Server Agent are running under a domain account setup by our network admin guys, and the DTC and RPC are running under the "NT AUTHORITY\NetworkService" account.
Any suggestions as to what this could be, or any other checks you think might be useful would be greatly appreciated.
Thanks in advance.
www.sqlAssociates.co.uk
July 20, 2007 at 12:00 am
did you install and configure MSDTC (control panel\add remove programs\windows components\application server)
Keep in mind that if the sql2005 box is running with windows 2003 and the sql2000 may be running with Windows 2000, you'll have to configure MSDTC not to authenticate mutualy !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 23, 2007 at 12:16 am
Just refer the link below.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=307570#bm315920
This was infact my first post here.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply