Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Linked server issue

Author  Topic 

aatishpatel
Starting Member

8 Posts

Posted - 2014-05-02 : 09:12:46
I get an error as below on SQL server 2008. The linked server tests successfully:
Msg 7391, Level 16, State 2, Line 10
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "PWOAPPLINK" was unable to begin a distributed transaction.

Can someome please help me on this. I know there's a old post but that's does not work as well.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2014-05-02 : 16:13:14
Is this what you were referring to?
http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-how-do-i-configure-sql-server-to-enable-distributed-transactions-via-linked-server.aspx?Redirected=true
Go to Top of Page
   

- Advertisement -