Forum Search:
Forum.Brain-Cluster.com: Brain Cluster Technical Forum
Ultimate forum for Technical Discussions

Home » Microsoft » Windows Server » Server Clustering » MSDTC on SQL cluster
MSDTC on SQL cluster [message #156803] Mon, 15 June 2009 13:28 Go to next message
Sitaram Pamarthi  is currently offline Sitaram Pamarthi  United States
Messages: 1
Registered: June 2009
Junior Member
I read through internet articles and understood that it for
ditributing the transactions across linked servers. But I am confused
how to configure this in cluster environment.

I already configured MSDTC resource and placed in default cluster
group. I have a SQL cluster group named DB1. Now my cluster group and
DB1 are hosted on same cluster node. When I trying to add a new
resource for DTC in DB1 group, it is giving an error that duplicate
resources can not be created.

Does it mean that is it enough if I have one DTC resource created per
cluster? My distributed translations are failing with below error and
I am not sure how it is related with DTC.

OLE DB provider "SQLNCLI" for linked server "DB1" returned message "No
transaction is active.".
Msg 7391, Level 16, State 2, Procedure spSyncspEmpBackground_test,
Line 7
The operation could not be performed because OLE DB provider "SQLNCLI"
for linked server "DB1" was unable to begin a distributed transaction.


Can any one help me?
RE: MSDTC on SQL cluster [message #156827 is a reply to message #156803] Thu, 25 June 2009 08:14 Go to previous message
sharath_bujji  is currently offline sharath_bujji
Messages: 7
Registered: June 2009
Junior Member
Hi,

Well, one DTC resource is enough for a cluster setup..however you have to
allow all nodes as owners on the resource to successfully fail over and fail
back.

Sharath

"Sitaram Pamarthi" wrote:

> I read through internet articles and understood that it for
> ditributing the transactions across linked servers. But I am confused
> how to configure this in cluster environment.
>
> I already configured MSDTC resource and placed in default cluster
> group. I have a SQL cluster group named DB1. Now my cluster group and
> DB1 are hosted on same cluster node. When I trying to add a new
> resource for DTC in DB1 group, it is giving an error that duplicate
> resources can not be created.
>
> Does it mean that is it enough if I have one DTC resource created per
> cluster? My distributed translations are failing with below error and
> I am not sure how it is related with DTC.
>
> OLE DB provider "SQLNCLI" for linked server "DB1" returned message "No
> transaction is active.".
> Msg 7391, Level 16, State 2, Procedure spSyncspEmpBackground_test,
> Line 7
> The operation could not be performed because OLE DB provider "SQLNCLI"
> for linked server "DB1" was unable to begin a distributed transaction.
>
>
> Can any one help me?
>
Goto Forum:
  


Current Time: Sun Sep 24 15:30:07 EDT 2017

Total time taken to generate the page: 0.05385 seconds
.:: Contact :: Home ::Sitemap::.

Powered by: FUDforum 3.0.0RC2.
Copyright ©2001-2009 FUDforum Bulletin Board Software