MSDTC config in cluster..

Question

MSDTC config in cluster..

bala2

SSCertifiable

Points: 5547
More actions
September 19, 2013 at 4:02 am

#277317

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...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173053 More actions · Answer 1

Short answer: yes.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

adb2303 SSCertifiable Points: 7588 More actions · Answer 2

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

bala2 SSCertifiable Points: 5547 More actions · Answer 3

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..

adb2303 SSCertifiable Points: 7588 More actions · Answer 4

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.

bala2 SSCertifiable Points: 5547 More actions · Answer 5

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

Brandie Tarvin SSC Guru Points: 173053 More actions · Answer 6

I would remove that other group and then add the MSDTC to the SQL cluster group.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.