Queries on High availibility in sql 2012

  • Hi, I am working in sql 2012 on HAG concepts,I would like to know whether it is possible to configure wfc on nodes which are

    already having Sql installed as stand alone and are a part of same domain.

    so that I can configure it for HAG later????

  • it shouldn't be a problem where the instances are already installed, ideally you would want to setup your cluster and soak test before you start deploying applications (clustered or non clustered)

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

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

  • OK Actually I am practicing both.

    Another problem in HAG is I am not able to connect to my secondary replica from HAG wizard in sql ssms but when I ping it shows connectivity...where I need to check for connection??

    In AD it shows both the memebers and also in FCM both node is showing up....

  • are the sql server services running??

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

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

  • yup both the services are running....

  • Make sure you add 5022 port in firewall exception on both the nodes.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply