July 9, 2009 at 1:27 pm
Am getting the infamous Msg 7391 error:
OLE DB provider "SQLNCLI" for linked server "DEVFTDB1" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Line 2
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "DEVFTDB1" was unable to begin a distributed transaction.
For the following TSQL
INSERT INTO newglogs.tblPromptPresortShipper
([PresortID],[ShipperID],[PromptID],[Style],[PresortDefault],[Optional],[Default],[ValidationMask],[LookupMask],[PromptMask])
EXEC DEVFTDB1.NEWG.newgnewg.spRetrievePromptPresortShipper;
If I run the 3rd line (EXEC) I get a result set, but when I include the insert I get the error msg. I goggled the net and read all (that I could find) about setting up DTC on the remote server and I seem to have everything set as it should be (including restarting the server).
Any ideas?
Mike Byrd
July 10, 2009 at 11:35 am
This may be caused by DTC not being configured for network access. This fixed the issue for me.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply