-
Msg 7391, unable to begin a distributed transaction.
Hi:
From SQL2005 server1 database DB1 tableA there is a trigger need to insert record to a remote server2 DB2 tableB, but with following error:
OLE DB provider "SQLNCLI" for linked server "server2" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure trInsUpdDel_Ability, Line 156 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "server2" was unable to begin a distributed transaction.
I tried on Server2 side:
A. SET REMOTE_PROC_TRANSACTIONS ON
B. sp_configure 'remote proc trans', 1
reconfigure with override
but still with above error when trigger fires from server1 DB1.
thanks
-D
-
If os is win2k3, you have to enable msdtc network access.
-
thank you rmiao. It is in win2k3 OS.
-D
-
He knows his shit
You are an absolute champ dude. Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|