Another MSDTC question

Question

Another MSDTC question

Kwisatz78

SSChampion

Points: 12478
More actions
October 15, 2010 at 5:59 am

#228069

Hi all I have been reading with interest the thread below
http://www.sqlservercentral.com/Forums/Topic990049-1549-3.aspx
I had a couple of my own questions in regards to this.
I have created two MSDTC resource groups and two SQL resource groups and now I want to move the MSDTC resources into their respective groups.
I have been reading that this is ok to do, however;
1. Will I need to reset up the dependencies?
2. Do I need to add an extra dependency for MSDTC on say the SQL Server Resource?
3. I had understood that SQL would automatically use the MSDTC resource in its own Resource group, is this not the case, do I need to preform a manual mapping?
Sorry if I have missed the answers to any of these questions in the other thread.

Viewing 5 posts - 1 through 5 (of 5 total)

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

Kwisatz78 SSChampion Points: 12478 More actions · Answer 1

Ok I had a go at this and just did a move of the MSDTC into the SQL group and the dependencies went with it.

I am still after answers to my other questions about whether I need to set any further dependencies for MSDTC on SQL and also if I need to perform a mapping?

Kwisatz78 SSChampion Points: 12478 More actions · Answer 2

Ok a bit more to add.

My opinion is that no extra dependencies needs to be added to MSDTC as there is an option for:

If restart is unsuccessful, fail over all resources in this service or application

and it is this that will handle how the resource group will handle particular failures of resources.

So this leads me onto mapping my MSDTC resources to my SQL instances. I am trying the syntax liek the following:

msdtc -tmMappingSet -name MSDTC_SQL - service MSSQL$instance1 -clusterResource MSDTC-Resource

when I press return nothing happens.

I also tried the command to return all currently mapped MSDTC with the following command:

MSDTC -tmMappingView *

However this produces the following;

Error occurred while trying to perform the above operation. Check the trace file for more information.

I have not managed to find the trace file - any idea where this is for a Clustered MSDTC resource?

Thanks

Kwisatz78 SSChampion Points: 12478 More actions · Answer 3

For those that are interested I had to launch cmd as administrator and I could execute the commands.

Perry Whittle SSC Guru Points: 234064 More actions · Answer 4

the only dependencies required for the MSDTC should already be in place. MSTDC depends upon its disk and network name resource! Yes, you will need admin privileges to create the mappings!

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

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