Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Cannot assign correct drives to DTC resource

Author  Topic 

VMotion
Starting Member

2 Posts

Posted - 2011-08-05 : 04:48:27
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.

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-08-05 : 17:26:06
Did you assign all other drives to default instance?
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-08-21 : 01:27:58
1. did you present all the drives to all the nodes in the cluster?
if no, then you go to disk management and do that
2. did you add the drives AFTER the cluster has been built?
if yes, you need to add those drives as cluster resources

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -