Cannot assign correct drives to DTC resource

Question

Cannot assign correct drives to DTC resource

Arthur.Bojilov

SSC Rookie

Points: 27
More actions
August 5, 2011 at 4:06 am

#241193

Hello everyone,
I have a three node SQL Server 2008 cluster on Windows 2008R2. It is running a default instance of SQL. I want to install another named instance of SQL. When creating a new Service or Application (DTC), when it comes to the page to assign a drive for the resource it shows only the quorum disk (Q:\). All other drives that I have assigned to the node are not being displayed. However, if I go to Disk Management I can see all LUNs that I have presented to the node.
Any suggestions what could be the cause.
Thank you.

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

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

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

this happened to me once and I'm trying to remember what the solution was! Sure it was something to do with how the resource was allocated in cluster manager. You must always work within cluster manager/admin console to allocate resource. I thought first that different sql installs can't share the same drives/luns - it may be that - it was about 7 years ago I had this problem and sadly I couldn't find it within my docs for a solution.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Arthur.Bojilov SSC Rookie Points: 27 More actions · Answer 2

Hi SSCrazy,

Thank you for the reply.

It is weird. My default SQL instance has its own DTC resource configured with a LUN allocated to it. And it is running on another node. But when I try to create a new DTC for a second SQL instance on the same cluster it sees only one drive that has been allocated already.

Anyway. I shall see if I can find a solution to it.

Regards,

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

You have added the LUNs as physical disks but not as cluster resources. Go into failover cluster manager and select add storage and add all new disks, you may then assign them to new applications\services.

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

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

Arthur.Bojilov SSC Rookie Points: 27 More actions · Answer 4

Hello SSCrazy,

Thank you for your hint. I added the disks to the storage and then I was able to assign the correct disk to DTC resource. I did not have to do that when creating the first instance of the MSDTC for first SQL instance. Anyway, thank you so much. I can now try installing the second SQL instance.

Regards,