Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

While I am creating the Cluster of sql server 2008 R2 I am getting error: Expand / Collapse
Author
Message
Posted Thursday, June 16, 2011 11:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 6:20 PM
Points: 1,202, Visits: 1,928
While I am creating the Cluster of sql server 2008 R2 I am getting error:

[Error Message]
The volume that contains SQL Server data directory G:\MSSQL10_50.MSSQLSERVER\MSSQL\Data does not belong to the cluster group.
[Details]
Microsoft.SqlServer.Configuration.SqlEngine.ValidationException: The volume that contains SQL Server data directory G:\MSSQL10_50.MSSQLSERVER\MSSQL\Data does not belong to the cluster group.


Thanks

Post #1127084
Posted Friday, June 17, 2011 12:29 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481
G Drive is a cluster drive or not ?
Have you added this drive in the Cluster Storage ?

Have you created first SQL Server group and then start installation or you are trying to install directly SQL Server 2008 R2 on the Cluster Mode


Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com
Post #1127098
Posted Friday, June 17, 2011 12:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 6:20 PM
Points: 1,202, Visits: 1,928
Thanks.

0. The Whole storage is provided from the Netapp.Even OS drive C: also.
1. Is it needed to create sql server group also.I hink Cluster service itself created it.
2. G drive is a clustered drive.
3. In validation report I am getting these error:


a.
An error occurred while executing the test.
There was an error validating that there are no unsigned drivers.
OpenService 'RemoteRegistry' failed.
Access is denied


b.
In Cluster Log it is giving errors of :

A1. The Cluster service failed to bring clustered service or application 'Available Storage' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.
A2. Cluster resource 'Cluster Disk 4' in clustered service or application 'Available Storage' failed.
A3. Cluster resource 'Cluster Disk 2' in clustered service or application 'Available Storage' failed.
A4. Cluster resource 'Cluster Disk 1' in clustered service or application 'Available Storage' failed.

c.
IsDomainNetworkTopOfBindings


Checks to see if the computer domain server is on the network that is bound to the top of the network order.
Warning
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order


Thanks

Post #1127105
Posted Tuesday, June 21, 2011 5:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
forsqlserver (6/17/2011)
Thanks.

0. The Whole storage is provided from the Netapp.Even OS drive C: also.

is this SQL Server a virtual machine?




forsqlserver (6/17/2011)

c.
IsDomainNetworkTopOfBindings


Checks to see if the computer domain server is on the network that is bound to the top of the network order.
Warning
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order


which operating system are the cluster nodes using and how many NICs do you have on each cluster node?


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1128912
Posted Tuesday, June 21, 2011 10:28 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481
check the LUN mapping of disk drives

these are shared disk or Drive comming from SAN storage?

are you installing this SQL server Installation on physical Server or Virtual Server ?


Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com
Post #1129444
Posted Monday, December 5, 2011 1:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 339, Visits: 788
Any solution to this issue? I'm getting the same problem.

SQL Server 2008 R2
Windows Server 2008 R2 SP1
SAN disks

I get it whether the disks are in available storage or if they are pre-added to the cluster resource group.

"The volume that contains SQL Server data directory <directory path> does not belong to the cluster group"

Thank you in advance.

John
Post #1216645
Posted Tuesday, December 13, 2011 6:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 1,306, Visits: 2,470
JohnnyDBA (12/5/2011)
Any solution to this issue? I'm getting the same problem.

SQL Server 2008 R2
Windows Server 2008 R2 SP1
SAN disks

I get it whether the disks are in available storage or if they are pre-added to the cluster resource group.

"The volume that contains SQL Server data directory <directory path> does not belong to the cluster group"

Thank you in advance.

John


1. Ensure that you have successfully created SQL Server resource group.
2. Make all the disks where you want to keep the data & log files a part of this group.
3. Ensure you have added the dependency on these drives.



Sujeet Singh
Post #1220844
Posted Tuesday, December 13, 2011 3:22 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 339, Visits: 788
Can you explain #3 further?

edit - the disks that contain the data and log paths are mounted volumes. They show up with strange paths that contain what looks like disk SIDs. When I change them to the logical path name using the drive letter, that's when I get the error. Does that mean I should leave the path with the SIDs and just add them that way?

edit2 - I tried everything and I still can't get this working.

I have 6 disks:
Cluster Disk 17 is Mounted Volume O:\archive
Cluster Disk 26 is Mounted Volume O:\backup
Cluster Disk 35 is Volume O:\
Cluster Disk 47 is Mounted Volume O:\data
Cluster Disk 55 is Mounted Volume O:\log
Cluster Disk 9 is Mounted Volume O:\temp

I tried installing with an existing resource group and disks added with all mounted disks having dependencies on disk 35
I tried installing with an existing resource group and disks added with all disk dependencies removed
I tried installing with an existing resource group and all disks in available storage
I tried installing with new resource group (specified in the installation screen) with all disks in available storage
I tried installing to the root of the mount points
I tried installing to subdirectories in the mount points

nothing works, same error every. single. time.

Please help
Post #1221236
Posted Tuesday, December 13, 2011 10:04 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 1,306, Visits: 2,470
Please go through this link, may help you to find the exact procedure:

http://www.mssqltips.com/sqlservertip/1709/install-sql-server-2008-on-a-windows-server-2008-cluster-part-3/



Sujeet Singh
Post #1221335
Posted Wednesday, December 14, 2011 7:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 339, Visits: 788
I did look through that article last night actually. I didn't see anything that I wasn't doing correctly based on the instructions.

I'd just like to point out one more thing. There is another forum post http://www.sqlservercentral.com/Forums/Topic961716-1549-1.aspx which points to another error on a different part of the setup. This is at the Cluster Disk Selection screen. I am also seeing this for the root disk that the mount points are connecting to (Disk 35). I am assuming the issues I'm experiencing here and at the section where you specify the data paths described above are related.

I'm going to give it another try this morning, then call Microsoft. If I get the answer from them I'll make sure to follow up here with what they say.
Post #1221662
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse