Clustered MSDTC

Posted by niel on Server Fault See other posts from Server Fault or by niel
Published on 2010-05-14T12:07:52Z Indexed on 2010/05/14 16:44 UTC
Read the original article Hit count: 256

Filed under:
|
|

Hi

I'm setting up a SQL cluster (SQL 2008), Windows 2008 R2.

I enable the network access on local dtc and then create a DTC resource in my cluster . the problem is that when i start up the resource it does nto pull through my settings to enable network access.

the log shows this:

MSDTC started with the following settings:

Security Configuration (OFF = 0 and ON = 1):

Allow Remote Administrator = 0,

Network Clients = 0,

Trasaction Manager Communication:

Allow Inbound Transactions = 0,

Allow Outbound Transactions = 0,

Transaction Internet Protocol (TIP) = 0,

Enable XA Transactions = 0,

Enable SNA LU 6.2 Transactions = 1,

MSDTC Communications Security = Mutual Authentication Required,

Account = NT AUTHORITY\NetworkService,

Firewall Exclusion Detected = 0

Transaction Bridge Installed = 0

Filtering Duplicate Events = 1

where when i restart the local dtc service it says this:

Security Configuration (OFF = 0 and ON = 1):

Allow Remote Administrator = 0,

Network Clients = 1,

Trasaction Manager Communication:

Allow Inbound Transactions = 1,

Allow Outbound Transactions = 1,

Transaction Internet Protocol (TIP) = 0,

Enable XA Transactions = 1,

Enable SNA LU 6.2 Transactions = 1,

MSDTC Communications Security = No Authentication Required,

Account = NT AUTHORITY\NetworkService,

Firewall Exclusion Detected = 0

Transaction Bridge Installed = 0

Filtering Duplicate Events = 1

settings on both nodes in teh cluster is the same. I have reinstalled and restarted to many times to mention.

Any ideas ?

© Server Fault or respective owner

Related posts about Windows

Related posts about msdtc