SQL Server 2008 MS DTC

Question

SQL Server 2008 MS DTC

Viewing 15 posts - 16 through 30 (of 39 total)

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

fenwicc Ten Centuries Points: 1053 More actions · Answer 1

This is from ms

http://msdn.microsoft.com/en-us/library/dd897474(BTS.10).aspx

the top part explains setting up an app with a disk and ip using windows 2008. You should be able to right click and add a disk resource like perry wrote. Make sure you are on the active node when you are trying to add the resource.

I set up a sql 2008 cluster in the lab yesterday and got the same error, but got pulled away before I could finish. I'll see if I can get back to it shortly.

I've read several of perry's replies in other forums and he definitely knows that socks come before shoes :-D, so If it's not working like he said, it might be an issue with the LUN. I'll go look and see what I can see.

Halcyon Ten Centuries Points: 1331 More actions · Answer 2

you need to create another shared disk, if you have got only 3 disks, 1 will be data,2nd - logs, 3rd -quorum and you will need to add one for DTC, unless you will add DTC as a resource to SQL server

Duran SSChampion Points: 13259 More actions · Answer 3

Hello Thank you for getting back as I know time is precious. GH, thank you for the link, this is the one that I am following, I'm fine with the initial setup and already have a network name and IP all set aside ready to be used, its just the part about choosing the disk at the end that prevents me from getting on with it, I believe that once the LUN is looked at it wil become available.

Halcyon,

'and you will need to add one for DTC, unless you will add DTC as a resource to SQL server'

Well, the idea is that I would add a disk for DTC and have this as the default so that if either node failed (I am setting up active/active) then the DTC would still be available (Perry's suggestion). I was wondering if I would need to add two DTC resource groups to the shared disk, one for each node or have them both use the same, and would I do this before or during SQL setup? I thought I would need to set up the default DTC before SQL install, this is the first time I have done this and Im finding that I have a few choices available to me, but not sure which would be the best to take.

Regards,

D.

Halcyon Ten Centuries Points: 1331 More actions · Answer 4

Hi Duran,

I have done some search (re a MS DTC error after unexpected shutdown), please have a look at this

http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/c751c901-6fbf-48b1-a079-6b91e738f67b

As for your question:

Well, the idea is that I would add a disk for DTC and have this as the default so that if either node failed (I am setting up active/active) then the DTC would still be available (Perry's suggestion). I was wondering if I would need to add two DTC resource groups to the shared disk, one for each node or have them both use the same, and would I do this before or during SQL setup? I thought I would need to set up the default DTC before SQL install, this is the first time I have done this and Im finding that I have a few choices available to me, but not sure which would be the best to take.

I would just have a shared disk for MS DTC (as I have done it) and set it up as clustered resource and do it before SQL setup. You can do it via cluster manager, right click services & applications and then configure a service or application, you would require a shared disk 2GB and an ip for it

Duran SSChampion Points: 13259 More actions · Answer 5

Hello Halcyon,

I have my 2GB drive ready, do you think I should create two groups in the drive for each node, or do you think I should just have a default for both. If I have one for both, will one node going down effect the other?

Regards,

D.

Halcyon Ten Centuries Points: 1331 More actions · Answer 6

Hi Duran,

microsoft white paper SQLServer Failover Cluster:

On Windows Server 2008, you can install multiple instances of MSDTC on a single failover cluster. The first instance of MSDTC that is installed will be the cluster default instance of MSDTC. This can be changed via the Component Services Management Console (dcomcnfg). To modify this, perform the following actions:

1.On the Start menu, click Run, type dcomcnfg and then press ENTER to launch the Component Services Management Console.

2.Expand Computers, and then right-click My Computer.

3.Click Properties, click the MSDTC tab, and then select the default coordinator for your cluster.

SQL Server 2008 will take advantage of an instance of MSDTC installed to the SQL Server’s local cluster resource group by automatically using the instance of MSDTC. However, individual applications can be mapped to any instance of MSDTC on the cluster.

You can find more tips and considerations for installation and set up of MSDTC there.

Can you please keep us updated with your installation progress.

Thank you

Duran SSChampion Points: 13259 More actions · Answer 7

Hello,

Thank you very much, yep, will let you know how I get on for sure. I have tried the suggestion above, but it does not work out. I get to the MSDTC tab but there are no choices in the drop down box, so looked to clear the 'Use Local Coordinator' check box but there wasnt one.

I was going to configure 2 DTC resources from cluster manager via services and applications and place them on the new disk that I had added. Is the result the same, or is this different to what is suggested above?

Thank you,

D.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

Create a clustered DTC resource and put it into the same resource group as your clustered SQL Server instance.

Then create a mapping to the DTC resource for the SQL Server instance by using the msdtc.exe command line

Check here for more details

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Halcyon Ten Centuries Points: 1331 More actions · Answer 9

Evening Perry,

can I confirm the steps:

1) Windows Cluster

2) SQL Server Cluster

3) Then add MSDTC to the SQL SErver application via right click application, add resource,more resources - 2 add distribute transaction coordinator?

Or whatever I do I still need to map resource via your link?

Also, is this configuration valid if my cluster is active/active?

Perry Whittle SSC Guru Points: 234013 More actions · Answer 10

Halcyon (10/11/2010)
Evening Perry,
can I confirm the steps:
1) Windows Cluster
2) SQL Server Cluster
3) Then add MSDTC to the SQL Server application

That's the steps you need to follow

Halcyon (10/11/2010)
via right click application, add resource,more resources - 2 add distribute transaction coordinator?

however you wish to create the DTC resource is up to you. You could create a DTC in a new group and then move the resources to the SQL group. Doing it the way you have mentioned just means creating the resources separately!

Halcyon (10/11/2010)
Or whatever I do I still need to map resource via your link?

Yes you need to use the MSDTC.exe command line to map the DTC resource to the clustered SQL Server service

syntax is as follows:

msdtc.exe -tmMappingSet -name

[-exe <pathname> | -service <full service name> | -complusappID <app ID>]

[-local|-clusterResourceName <resource name>]

Halcyon (10/11/2010)
Also, is this configuration valid if my cluster is active/active?

This has no bearing at all!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Halcyon Ten Centuries Points: 1331 More actions · Answer 11

hi Perry,

Thank you for your previous reply.

New questions though...

Halcyon (10/11/2010)

--------------------------------------------------------------------------------

Or whatever I do I still need to map resource via your link?

Yes you need to use the MSDTC.exe command line to map the DTC resource to the clustered SQL Server service

syntax is as follows:

msdtc.exe -tmMappingSet -name

[-exe <pathname> | -service <full service name> | -complusappID <app ID>]

[-local|-clusterResourceName <resource name>]

so, my msdtc is created as a separate cluster service, i logged to my cluster (not the individual node) and tried to run msdtc.exe -tmpMappingSet * - have received an error;

Also, I have check my dtc via MMC and it seems my MSDTC network access is not configured - any advice as to what will be affected if it is not set up

Thank you

Perry Whittle SSC Guru Points: 234013 More actions · Answer 12

This post explains it a little more

http://www.pluralsight-training.net/community/blogs/jimjohn/archive/2008/03/23/50536.aspx

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Halcyon Ten Centuries Points: 1331 More actions · Answer 13

thank you, Perry

good post, do you have some other resorces especially regarding cluster resources configuration:

we have got service going down and not being restarted

Thank you

Perry Whittle SSC Guru Points: 234013 More actions · Answer 14

Halcyon (10/12/2010)
we have got service going down and not being restarted
Thank you

Sounds dire and beyond the scope of forum posts. What is your location, I am available on a contract basis and would be free at the end of this week!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Shabba SSCertifiable Points: 5007 More actions · Answer 15

Shabba

SSCertifiable

Points: 5007

October 13, 2010 at 2:38 am

#1236033

Never one to miss an opportunity eh Perry?!