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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » While I am creating the Cluster of sql server...

22 posts, Page 1 of 3

1 2 3 »»»

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

Rate Topic

Display Mode

Topic Options

Author

Message

forsqlserver

Posted Thursday, June 16, 2011 11:28 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186, Visits: 1,852

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

Syed Jahanzaib Bin hassan

Posted Friday, June 17, 2011 12:29 AM

SSC-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

forsqlserver

Posted Friday, June 17, 2011 12:49 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186, Visits: 1,852

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

Perry Whittle

Posted Tuesday, June 21, 2011 5:45 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #1128912

Syed Jahanzaib Bin hassan

Posted Tuesday, June 21, 2011 10:28 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481

Post #1129444

JohnnyDBA

Posted Monday, December 05, 2011 1:04 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:36 AM
Points: 334, Visits: 706

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

Divine Flame

Posted Tuesday, December 13, 2011 6:40 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:00 PM
Points: 1,076, Visits: 1,914

JohnnyDBA (12/5/2011)

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.

- Divine Flame

Post #1220844

JohnnyDBA

Posted Tuesday, December 13, 2011 3:22 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:36 AM
Points: 334, Visits: 706

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

Divine Flame

Posted Tuesday, December 13, 2011 10:04 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:00 PM
Points: 1,076, Visits: 1,914

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/

- Divine Flame

Post #1221335

JohnnyDBA

Posted Wednesday, December 14, 2011 7:22 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:36 AM
Points: 334, Visits: 706

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 »

22 posts, Page 1 of 3

1 2 3 »»»

Permissions