locked
AlwaysOn Availability Group RRS feed

  • Question

  • Hi,

    Is it possible or good practice to install sql server instances on 2 servers before creating failover cluster for always on availability group? Server team will create failover cluster for availability group later on and then we will configure always on group. So my question is if I install sql server instances on each server, before creating cluster, whether there will be any issue?

    Thanks

    Friday, June 5, 2015 8:37 PM

Answers

  • There is no predefined / mandatory sequence. Once both (SQL and Windows Cluster) are deployed, then only you can enable feature via SQL Server Configuration Manager and use it after restart.

    Balmukund Lakhani
    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter | Facebook
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    • Marked as answer by DBA_LEARNER Saturday, June 6, 2015 4:48 AM
    Saturday, June 6, 2015 12:05 AM
  • Whether you install SQL instances before or after the WSFC is built/configured doesn't make a difference. 
    Friday, June 5, 2015 8:50 PM

All replies

  • Whether you install SQL instances before or after the WSFC is built/configured doesn't make a difference. 
    Friday, June 5, 2015 8:50 PM
  • There is no predefined / mandatory sequence. Once both (SQL and Windows Cluster) are deployed, then only you can enable feature via SQL Server Configuration Manager and use it after restart.

    Balmukund Lakhani
    Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter | Facebook
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    • Marked as answer by DBA_LEARNER Saturday, June 6, 2015 4:48 AM
    Saturday, June 6, 2015 12:05 AM
  • When its a new / clean install the sequence isn't a biggie (except for a few extra checks that SQL will do while being installed on a WSFC participant box). But when it comes to patching & upgrades.... the WSFC should be up & good. I've seen patching failures for some reasons there.

    yup

    Sunday, June 7, 2015 6:30 AM