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

MSDTC config in cluster.. Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 4:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Hi All,

Windows server 2008 r2
I have to install sql 2008 r2 cluster for i need a help for msdtc config?

Steps that i have followed:

1)MSDTC configuration:

i have configured msdtc instance in seprate group.

2)install sql cluster


now my dout is do we need to map the sql instance with MSDTC instance or not.?

Please reply its urgent...
Post #1496287
Posted Thursday, September 19, 2013 7:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:28 AM
Points: 5,584, Visits: 6,380
Short answer: yes.

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1496396
Posted Thursday, September 19, 2013 8:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:47 AM
Points: 837, Visits: 2,460
please read: http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx
Post #1496411
Posted Friday, September 20, 2013 2:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Thanks for reply,

Can you help me in command to map the sql instane with MSDTC instance names .


msdtc -tmMappingSet -name <MappingName> -service <SQLServerServiceName> -clusterResource <MSDTCResourceName>


Here What is Mappingname refering to....

what name i have to give



Thans in advance..
Post #1496742
Posted Friday, September 20, 2013 3:35 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 8:47 AM
Points: 837, Visits: 2,460
Hi,
On 2008 R2, when you put the MSDTC resource in the same cluster group as your SQL Server instance, it will (should) do the mapping automatically.
Post #1496767
Posted Friday, September 27, 2013 2:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Thanks for reply,


Here have configured MSDTCs in Spearate group.
So i need to map them to specified instance.

Is it possible to move the Msdtc to slg group from Msdtc group?
and what are the steps for it.

which way is good to follow

1)mapping to specifed instance
or
2)moving to sql group

Kindly suggest me...
Advance thanks
Post #1499261
Posted Friday, September 27, 2013 6:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:28 AM
Points: 5,584, Visits: 6,380
I would remove that other group and then add the MSDTC to the SQL cluster group.

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1499334
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse