Event ID 4879, "The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction".
I have 2 servers running windows 2008 64-bit datacenter edition. I have enabled DTC service http://msdn.microsoft.com/en-us/library/dd327979(CS.90).aspx. But still DTC services are not talking to each other. I checked for the port 135, its opened.
SQL 2008 is installed on both servers. Linked server is working fine but DTC has issue. Error found in sql query is
"The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction".
Event ID : 4879
Event Viewer message:
"OLE DB provider "SQLNCLI10" for linked server "server-01" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 2"
Is there any more settings to be done to enable this or is this issue is due to 64bit??
SQL 2008 is installed on both servers. Linked server is working fine but DTC has issue. Error found in sql query is
"The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction".
Event ID : 4879
Event Viewer message:
"OLE DB provider "SQLNCLI10" for linked server "server-01" returned message "No transaction is active.".
Msg 7391, Level 16, State 2, Line 2"
Is there any more settings to be done to enable this or is this issue is due to 64bit??
ASKER
I could not even install this hotfix. It said "there are no sql server instances or shared features that can be updated on this computer"
I am using sql 2008 sp1. So downloaded cumilative hotfix for sql2008 sp1, but got same error "The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction.
I am using sql 2008 sp1. So downloaded cumilative hotfix for sql2008 sp1, but got same error "The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "server-01" was unable to begin a distributed transaction.
ASKER
forgot to mention another that servers are not in domain. They are in workgroup.
I updated sql2008 with sp2 but still no luck.
I ran into the same message in an SSIS package I was trying to continue to work on after having recently installed SS2008 and VS2008 (BIDS) on a Virtual Machine. What I wound up doing was deleting the old OLEDB connection manager and adding a new one . . . apparently, the old one (that had been working fine before the SS/VS 2008 SP1 upgrade had been installed) was something like an SQLNCLI1 instead of the SQLNCLI10.
Please check DTC configuration, authentication. You must use the No Authentication Required for Transaction Manager Communication. It is only working setting for workgroup computers.
Also re-check other options. You have to both Incomming and Outgoing connection.
Setting on both servers should be same.
Also re-check other options. You have to both Incomming and Outgoing connection.
Setting on both servers should be same.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, there was a bug reported in CU2 to have been fixed and came back in CU3 / CU4, so maybe SP1 is similarly afflicted (havent checked which cumulative updates belong where).
Might also have been a problem / difficulty with installation/upgrades ? Sometimes (and not a good answer - but not really "copping out" either) big mysteries in SQL are best resolved with a re-install... But they do need to be big mysteries to warrant such a dramatic step.
Might also have been a problem / difficulty with installation/upgrades ? Sometimes (and not a good answer - but not really "copping out" either) big mysteries in SQL are best resolved with a re-install... But they do need to be big mysteries to warrant such a dramatic step.
ASKER
Thanks Mark,
We are planning to install SQL standard 2008 R2 64-bit as solution was not found. Lets see..
We are planning to install SQL standard 2008 R2 64-bit as solution was not found. Lets see..
Have no problem with the accepted answer going to anuboggaram (http:#33617053) because that is pretty much the fix - either upgrade, or retrograde, think there has since been a SP that does fix it, but the details given in http:#33602211 are correct and do explain that problem and so deserves an assist.
All,
Following an 'Objection' by mark_wills (at https://www.experts-exchange.com/questions/26721533/Automated-Request-for-Review-Objection-to-Accept-Q-26440907.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
At this point I am going to re-start the auto-close procedure.
Thank you,
Vee_Mod
Experts-Exchange Moderator
Following an 'Objection' by mark_wills (at https://www.experts-exchange.com/questions/26721533/Automated-Request-for-Review-Objection-to-Accept-Q-26440907.html) to the intended closure of this question, it has been reviewed by at least one Moderator and is being closed as recommended by the Expert.
At this point I am going to re-start the auto-close procedure.
Thank you,
Vee_Mod
Experts-Exchange Moderator
http://support.microsoft.com/kb/954950