August 30, 2014 at 4:06 am
OLE DB provider "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" returned message "The 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 "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" was unable to begin a distributed transaction.
August 30, 2014 at 6:47 am
techmaark (8/30/2014)
OLE DB provider "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" returned message "The 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 "SQLNCLI10" for linked server "REPLLINK_TECHMARK952933815_TEST_CLIEN-672667892_REPUPDSUB2109712029_TEST_SERVE-1760219189" was unable to begin a distributed transaction.
Can you tell us a little more about the environment, the problem, how it started, how things where working before etc.
At the first glance it looks like BizTalk MSDTC problem.
😎
August 30, 2014 at 9:08 am
thanx for reply
there is 2 system in different location and windows server 2008 r2 installed on both. and sqlserver 2008 r2 installed on both the machine.
i m trying to build a replication with updateable subscription.publisher build successfully but at the time of adding subscriber and executing subscription that time i m facing this error no. 7391
on both server link server test connection passed.
i have confiqured MSDTC properly according to my knowledge and dts on both pc running.firewall on both pc off
i have attached a screenshot of msdtc setting if any further setting required pls tell me..
thanx in advance
August 30, 2014 at 9:13 am
Quick thought, have a look at this page Enable Network Access Securely for MS DTC, guess this is your problem.
😎
August 30, 2014 at 9:24 am
pls check screenshot of msdtc setting attached
August 30, 2014 at 9:37 am
techmaark (8/30/2014)
pls check screenshot of msdtc setting attached
First thought and if I remember correctly, set the NetworkDtcAccessTip (Transaction Internet Protocol (TIP)) to 1. Do check on technet though as my grey-cell memory isn't as it used to be;-)
😎
August 30, 2014 at 10:01 am
I have done changes in registry as u said i still facing same error .when trying to execute this script.
Procedure details:
use [TEST_SERVER]
exec sp_link_publication @publisher = N'TECHMARK', @publisher_db = N'TEST_CLIENT', @publication = N'123', @distributor = N'TECHMARK', @security_mode = 2, @login = null, @password = null
GO
Error:
OLE DB provider "SQLNCLI10" for linked server "TECHMARK" returned message "The 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 "SQLNCLI10" for linked server "TECHMARK" was unable to begin a distributed transaction.
August 30, 2014 at 10:16 am
Can you ping the servers in both directions from each other using the server names, not the ip address (oops that sounds twisted:-))?
😎
August 31, 2014 at 9:10 am
server pings client but client not ping to server but i can remotely connect with server
August 31, 2014 at 9:15 am
techmaark (8/31/2014)
server pings client but client not ping to server but i can remotely connect with server
As a quick fix, add a HOST entry for the server on the client system.
😎
September 1, 2014 at 1:25 am
can u please guide me steps how to add host name thanx
September 15, 2014 at 3:39 am
thanx for reply
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply