cancel
Showing results for 
Search instead for 
Did you mean: 

Actually Wally - I've hit

switchbone
Level 3

Actually Wally - I've hit another snag, which hopefully you can help with.blush

Following the Veritas™ Cluster Server Implementation Guide for Microsoft SQL Server 2008 and 2008 R2, I'm attempting to create the MSDTC resource group as explained in Chapter 7.

I have a separate disk (I: MSDTC) ready on the node I'm configuring the resource on, and I'm using SQL Server Agent Configuration Wizard to create the resource group with. 

After specifiying the name of the group and selecting both nodes of the cluster to configre the group on, I click Next and then receive the following error message:

Capture.JPG

I've done some research on the error but haven't found anything other than a patch: https://sort.symantec.com/patch/detail/7842 which includes the hotfix Hotfix_6_0_10011_3247363 and mentions the above error, but is intended to fix an issue with the "Windows FileShare" and "SQL Server 2008" agent configuration wizards.

Can you offer any advice on the error, please?

Thanks,

SB.

 

1 ACCEPTED SOLUTION

Accepted Solutions

switchbone
Level 3

Hi Wally,

Actually - I found a workaround:

  1. Create the VMDKs for node 1 on SCSI ID 1:x (as you recommended)
  2. Run the SQL Config Wizard but add only node 1 and configure as normal
  3. Once the MSDTC resource is created, manually edit the configuration in Cluster Explorer to include node 2, its public MAC address, signatures, disk paths, VMWareDisks resource, etc.

Once I'd configured this I was successfully able to switch the MSDTC resource back and forth across node 1 and node 2.

Thanks for all of your pointers and advice - much appreciated!

Regards,

John (SB).

View solution in original post

10 REPLIES 10

mikebounds
Level 6
Partner Accredited

Is the volume that the I:drive is created on in a different diskgroup to the volume SQL is on - this must be the case if you want MSDTCC in a separate service group, i.e. you not only have to have MSDTC on a separare volume to SQL - it must also be in a separate diskgroup.

Mike

Wally_Heim
Level 6
Employee

Hi SB,

The wizards that come with the base VCS product directly on the nodes are not VMWare aware like the wizards that are that launch from the vCenter console plugin.  As such, you will need to do a workaround to get the bulk of the group created and then make some manual configuration changes to the VMWare components.

Here are the basics of what you need to do.

1. Temporarily assign the disk to all servers in the cluster but only have the drive letter assigned on one system where you will run the wizard.  The disks need to be added to a virtual scsi adaptor other than the one that the OS drive is on.  AKA scsi ID 1:x would be fine.

2. Run the wizard to create the MSDTC service group.

3. Remove/unassign the disks from all systems except the one where the wizard was run on.

4. Create a VMwareDisks resource in the MSDTC service group and link it below the other disk resources in this cluster.

5. Test online and failover to ensure that the MSDTC group works as expected.

Note: The MSDTC service group will automatically show up in the vCenter's Symantec HA Console tab since you already have a SQL service group created on these nodes.

If you have any problems and need more direct assistance, please open a case with Symantec Technical Support.  We will be able to assist you with this configuration as needed.

Thank you,

Wally

switchbone
Level 3

Hi Wally - thanks for the swift reply.

I've followed most of the steps but am only able to select the first of the two nodes via the SQL Wizard, so I've configured the MSDTC group only on the first node. If I add the second node, I get the same failure.

I did put the new VMDK on 1:0 on the first node which seemed to work for that first node.

Can you clarify this step: Temporarily assign the disk to all servers in the cluster but only have the drive letter assigned on one system where you will run the wizard.

Thanks,

SB

 

 

Wally_Heim
Level 6
Employee

Hi SB,

Assign the VMDK file to SCSI id 1:0 on both nodesat the same time and try running the wizard.  The wizards on the nodes directly are looking for the same disks to be available to both nodes at the same time.

Again, you would like direct help please open a support case.

Thank you,

Wally

switchbone
Level 3

Hi Wally,

This doesn't work - I attempt to assign the same VMDK ([datastore] node1server/6.vmdk) to both nodes, I get the following error:

Capture1.JPG

The first node locks the file and when I attempt to attach it to the second node, it complains that the file is locked - which makes sense.

Is there another way of creating the MSDTC resource?

OR - as I can at least add 1 node using the SQL Config Wizard, is there a a way of manually introducing the second node via Cluster Manager?

Thanks again,

SB. 

switchbone
Level 3

Hi Wally,

Actually - I found a workaround:

  1. Create the VMDKs for node 1 on SCSI ID 1:x (as you recommended)
  2. Run the SQL Config Wizard but add only node 1 and configure as normal
  3. Once the MSDTC resource is created, manually edit the configuration in Cluster Explorer to include node 2, its public MAC address, signatures, disk paths, VMWareDisks resource, etc.

Once I'd configured this I was successfully able to switch the MSDTC resource back and forth across node 1 and node 2.

Thanks for all of your pointers and advice - much appreciated!

Regards,

John (SB).

Wally_Heim
Level 6
Employee

Hi John (SB),

Good to hear that you got around this issue.  Have you tested MSDTC to ensure that it is working as expected?  If not here is a quick way to test.

1. Online the MSDTC service group on node 1.

2. Online the SQL service group on node 1.

3. Open SQL Query Analyzer (in SQL Management Studio) and execute the following T-SQL statement

  Begin Distributed Transaction

If MSDTC is working correctly it should simply return the following line

   Command(s) completed successfully.

If it returns an error then MSDTC is not working correctly.

Test failing over the MSDTC and SQL groups to different nodes in the cluster to test each combination possible to ensure that all nodes are working as expected.

Thank you,

Wally

Kimberley
Level 6
Partner

Note: I split this thead from a prior thread and the comments didn't move over directly, so I have copied them. My apologies for the duplication of comments between the two threads.

Wally_Heim
Level 6
Employee

John (SB) - do you have an update on this issue?  Is everything working ok now?

Kimberley, thank you for splitting this issue off from the other post.

-Wally

switchbone
Level 3

Hi Wally - yes I can confirm that all is working as planned.

Thanks for your help.

 

Regards,

John.