MSDTC Configuration Issue

dear team,

we have configured msdtc in windows server 2003 our application. we need sync 2 databases (procedure: cap_exposureinsert) unfortunately receive error message in our event log. same same settings have done in our other environment , didn’t face issue.

message: operation not performed because ole db provider "sqlncli" linked server "mblc_to_mbafc_link" unable begin distributed transaction.

further detail please reviews complete error log below.

09/26/2012 15:01:11

type : system.data.sqlclient.sqlexception, system.data, version=1.0.5000.0, culture=neutral, publickeytoken=b77a5c561934e089

message: operation not performed because ole db provider "sqlncli" linked server "mblc_to_mbafc_link" unable begin distributed transaction.

source : .net sqlclient data provider

help link :

errors : system.data.sqlclient.sqlerrorcollection

class : 16

linenumber : 129

number : 7391

procedure : cap_exposureinsert

server : test server

state : 2

targetsite : int32 update(system.data.datarow[], system.data.common.datatablemapping)

stack trace :    at system.data.common.dbdataadapter.update(datarow[] datarows, datatablemapping tablemapping)

   at system.data.common.dbdataadapter.update(datarow[] datarows)

   at cap.persistence.components.exposure.capexposurepo.flush(dataset data, dataviewrowstate rowstate, idbconnection connection, idbtransaction transaction)

   at cap.persistence.components.exposure.capexposurepo.insert(dataset data, idbconnection connection, idbtransaction transaction)

additional info:

machinename : test server

timestamp : 2012/09/26 7:01:11 am

fullname : microsoft.practices.enterpriselibrary.exceptionhandling, version=1.1.0.0, culture=neutral, publickeytoken=null

appdomainname : /lm/w3svc/1/root/cap-1-129930552048230000

threadidentity : huan jingx

windowsidentity : nt authority\network service

category: {cap}

priority: 0

eventid: 100

severity: error

title:enterprise library exception handling

machine: test server

application domain: /lm/w3svc/1/root/cap-1-129930552048230000

process id: 5320

process name: c:\windows\system32\inetsrv\w3wp.exe

win32 thread id: 2924

thread name:

extended properties:

---

naveed amir

hello naveed,

please refer following discussions , see if of suggestions given thread's helps 

ole db provider "sqlncli" linked server " " returned message "no transaction active."

http://www.sqlservercentral.com/forums/topic415654-149-1.aspx

problem msdtc 

http://social.technet.microsoft.com/forums/en-us/winservergen/thread/eb8835d9-5f5b-4df2-8c68-4a61d5e44d6b

thanks

---

regards, santosh

i not represent organisation work for, opinions expressed here own.

this posting provided "as is" no warranties or guarantees , confers no rights.

Windows Server  >  Windows Server General Forum