Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Msg 7391, Level 16, State 2, Line 1 Expand / Collapse
Author
Message
Posted Saturday, August 30, 2014 4:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:07 AM
Points: 9, Visits: 23
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.
Post #1608815
Posted Saturday, August 30, 2014 6:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,253, Visits: 6,170
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.
Post #1608826
Posted Saturday, August 30, 2014 9:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:07 AM
Points: 9, Visits: 23
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


  Post Attachments 
msdtc.jpg (4 views, 74.61 KB)
Post #1608882
Posted Saturday, August 30, 2014 9:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,253, Visits: 6,170
Quick thought, have a look at this page Enable Network Access Securely for MS DTC, guess this is your problem.
Post #1608885
Posted Saturday, August 30, 2014 9:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:07 AM
Points: 9, Visits: 23
pls check screenshot of msdtc setting attached


  Post Attachments 
msdtc.jpg (3 views, 74.61 KB)
MSDTCRegistry.png (5 views, 62.96 KB)
Post #1608890
Posted Saturday, August 30, 2014 9:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,253, Visits: 6,170
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
Post #1608894
Posted Saturday, August 30, 2014 10:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:07 AM
Points: 9, Visits: 23
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.
Post #1608911
Posted Saturday, August 30, 2014 10:16 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,253, Visits: 6,170
Can you ping the servers in both directions from each other using the server names, not the ip address (oops that sounds twisted)?
Post #1608926
Posted Sunday, August 31, 2014 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 10, 2014 11:07 AM
Points: 9, Visits: 23
server pings client but client not ping to server but i can remotely connect with server
Post #1609156
Posted Sunday, August 31, 2014 9:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:37 PM
Points: 2,253, Visits: 6,170
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.
Post #1609157
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse