Tuesday, January 10, 2012

Linked Server - Distributed Transaction Issue

--Error Message

Executed as user: domainName\user. The operation could not be performed because OLE DB provider "SQLNCLI10"
for linked server "LSName" was unable to begin a distributed transaction. [SQLSTATE 42000] (Error 7391)
OLE DB provider "SQLNCLI10" for linked server "LSName" returned message "The partner transaction manager
has disabled its support for remote/network transactions.". [SQLSTATE 01000] (Error 7412). The step failed.

EXEC sp_serveroption @server = 'LSName',@optname = 'remote proc transaction promotion', @optvalue = 'False' ;