distributed transaction in MS SQL Server
Dear all,
hai i m trying to execute query in remote server from my local server
when i select or update query from web server it work fine
but when i exectue insert statement from Stored procedure in Web server.
it give followign error.
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "75.125.162.34,8327" was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server
"75.125.162.34,8327" returned message
"The transaction manager has disabled its support for remote/network transactions.".
i have set the msdtc setting already
and msdtc service is enable in my both client pc as well as server pc
if any body know wht the setting require in remote pc
plz let me know
