SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


While I am creating the Cluster of sql server 2008 R2 I am getting error:


While I am creating the Cluster of sql server 2008 R2 I am getting error:

Author
Message
forsqlserver
forsqlserver
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2048
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
Syed Jahanzaib Bin hassan
Syed Jahanzaib Bin hassan
SSC Eights!
SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)

Group: General Forum Members
Points: 914 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
forsqlserver
forsqlserver
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2048
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
Perry Whittle
Perry Whittle
SSC-Insane
SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)SSC-Insane (20K reputation)

Group: General Forum Members
Points: 20108 Visits: 17244
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" ;-)
Syed Jahanzaib Bin hassan
Syed Jahanzaib Bin hassan
SSC Eights!
SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)SSC Eights! (914 reputation)

Group: General Forum Members
Points: 914 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
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
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
Divine Flame
Divine Flame
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2297 Visits: 2816
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
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
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
Divine Flame
Divine Flame
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2297 Visits: 2816
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
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search