June 6, 2012 at 2:01 am
Hi All
I have a working 2008 Windows 2 node Cluster. No clustered applications have been installed yet
I need to install SQL Server on this cluster
When I run the clustered installation of SQL Server, does it apply the installation on both nodes in the cluster or will I still need to run the SQL Installation Add Node on the other node?
Thanks
Derek
June 6, 2012 at 3:23 am
you still need to run the SQL Installation Add Node on the other node to put binaries.
June 6, 2012 at 3:26 am
bipan (6/6/2012)
you still need to run the SQL Installation Add Node on the other node to put binaries.
Thanks
June 6, 2012 at 5:08 am
Hi,
Unlike SQL Server 2005, SQL Server 2008 doesn't get installed on the remote nodes as the remote installation concept is not available in it. Hence, we need to do the add node from all the other nodes in the cluster.
Thanks.
June 6, 2012 at 6:21 am
SQLSACT (6/6/2012)
Hi AllI have a working 2008 Windows 2 node Cluster. No clustered applications have been installed yet
I need to install SQL Server on this cluster
When I run the clustered installation of SQL Server, does it apply the installation on both nodes in the cluster or will I still need to run the SQL Installation Add Node on the other node?
Thanks
Derek
Derek, Is this for Active/Active or Active/Passive cluster?
Regards,
TA
Regards,
SQLisAwe5oMe.
June 6, 2012 at 6:27 am
SQLCrazyCertified (6/6/2012)
SQLSACT (6/6/2012)
Hi AllI have a working 2008 Windows 2 node Cluster. No clustered applications have been installed yet
I need to install SQL Server on this cluster
When I run the clustered installation of SQL Server, does it apply the installation on both nodes in the cluster or will I still need to run the SQL Installation Add Node on the other node?
Thanks
Derek
Derek, Is this for Active/Active or Active/Passive cluster?
Regards,
TA
Active\Active
I'm having another problem now
When I try to install SQL, it fails at the Setup Support Rules screen
Error Logs show: The cluster either has not been verified or there are errors or failures in the verification report.
I have done the validation and everything has passed but I still get this error
Stuck!!
June 6, 2012 at 6:33 am
Which rule is failing in the Setup support rules ?
Cluster Verification errors? or Warnings ? Can you send me a screenshot to rgullapalli3@live.com ?
June 6, 2012 at 6:55 am
RaviTeja Gullapalli (6/6/2012)
Which rule is failing in the Setup support rules ?Cluster Verification errors? or Warnings ? Can you send me a screenshot to rgullapalli3@live.com ?
According to the Log it's failing at the Cluster_VerifyForErrors rule
June 6, 2012 at 7:07 am
run your cluster verification and ensure there are no errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:08 am
Can you try to insall the SQL Server FC using the SkipRules option ? This should be run through the CMD. Open the CMD as "Run as Administrator" option.
Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster
June 6, 2012 at 7:19 am
Perry Whittle (6/6/2012)
run your cluster verification and ensure there are no errors
Hi Perry
I ran the Verification and there are no errors reported
There is one warning for "Validate Network Communication" And the description is:
Node 1 is reachable from Node 2 by only one pair of interfaces. It is possible that this network path is a single point of failure for communication within the cluster. Please verify that this single path is highly available or consider adding additional networks to the cluster.
And my SQL Server installation still fails on the same rule
Thanks
Derek
June 6, 2012 at 7:28 am
RaviTeja Gullapalli (6/6/2012)
Hi,Unlike SQL Server 2005, SQL Server 2008 doesn't get installed on the remote nodes as the remote installation concept is not available in it. Hence, we need to do the add node from all the other nodes in the cluster.
Thanks.
Derek,
Before you install SQL, you need to run the cluster validation wizard to make sure the hardware and hardware settings.are compatible with failover cluster. This is the new feature with 2008. Try running that and see if everything is valid before installing.
Regards,
TA
Regards,
SQLisAwe5oMe.
June 6, 2012 at 7:31 am
SQLSACT (6/6/2012)
Perry Whittle (6/6/2012)
run your cluster verification and ensure there are no errorsHi Perry
I ran the Verification and there are no errors reported
There is one warning for "Validate Network Communication" And the description is:
Node 1 is reachable from Node 2 by only one pair of interfaces. It is possible that this network path is a single point of failure for communication within the cluster. Please verify that this single path is highly available or consider adding additional networks to the cluster.
And my SQL Server installation still fails on the same rule
Thanks
Derek
Can you detail the current NIC setup you have on each node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 7:51 am
Perry Whittle (6/6/2012)
SQLSACT (6/6/2012)
Perry Whittle (6/6/2012)
run your cluster verification and ensure there are no errorsHi Perry
I ran the Verification and there are no errors reported
There is one warning for "Validate Network Communication" And the description is:
Node 1 is reachable from Node 2 by only one pair of interfaces. It is possible that this network path is a single point of failure for communication within the cluster. Please verify that this single path is highly available or consider adding additional networks to the cluster.
And my SQL Server installation still fails on the same rule
Thanks
Derek
Can you detail the current NIC setup you have on each node
According to our network guys, the servers have a direct fibre connection to the storage - I'm not sure if this makes sense
I noticed that there is a KB article for this error with a workaround by installing SQL via CMD Prompt
I don't want to go that route - I want to find the cause of the issue
I dont understand why the Rule fails if I ran the validation and there was no errors reported
Thanks
Derek
June 6, 2012 at 8:21 am
How many network cards are installed and what configuration?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply