Linked Server in Sql server
Posted on 2011-03-15
I have two instances of Sql server - Sql 2005 and Sql 2000. Sql 2005 is configured to work under Windows authentication running under Domain account.
and Sql2000 is configured for windows and Sql authentication and running under system account.
I have configured sql2000 as linked server under sql 2005 instance. I am able to run the stored procedure stored in sql 2000 instance. but when i try to insert locally from linked server procedure i am getting the following error.
OLE DB provider "SQLNCLI" for linked server "blrds" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 1
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "blrds" was unable to begin a distributed transaction.
Can some expert help me to overcome this error
Thanks in advance