Windows 2008 Cluster - Install SQL

  • 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

  • you still need to run the SQL Installation Add Node on the other node to put binaries.

  • bipan (6/6/2012)


    you still need to run the SQL Installation Add Node on the other node to put binaries.

    Thanks

  • 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.

  • SQLSACT (6/6/2012)


    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

    Derek, Is this for Active/Active or Active/Passive cluster?

    Regards,

    TA

    Regards,
    SQLisAwe5oMe.

  • SQLCrazyCertified (6/6/2012)


    SQLSACT (6/6/2012)


    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

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

  • Which rule is failing in the Setup support rules ?

    Cluster Verification errors? or Warnings ? Can you send me a screenshot to rgullapalli3@live.com ?

  • 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

  • run your cluster verification and ensure there are no errors

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • 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

    Ref: http://support.microsoft.com/kb/953748

  • 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

  • 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.

  • SQLSACT (6/6/2012)


    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

    Can you detail the current NIC setup you have on each node

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (6/6/2012)


    SQLSACT (6/6/2012)


    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

    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

  • 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