add node to VCS for SQL
Hello
Currently , I have 2 node cluser for SQL database.
There are requirement to add new node to the existing cluster.
If I install windows , sql installation & configuration as same as the exsing nodes.
The finally step are just adding the node to cluster and re-run the SQL agent configuration wizard to reconfigure the SQL service group.
I am not sure about the additional step that must be concern.
Thank you.
Hi pgm10s,
It sounds like you have everything covered fairly well. The installation of SQL needs to have the same path to the binaries as the existing nodes. The path to the master database files can be different. But don't worry, the SQL service group configuration wizard will fix that difference. You just need to run the wizard from an existing node in the cluster where the share storage is already online and then add the new node via the wizard.
Be sure to install any SQL patches on the new node that may have been installed on the 2 existing SQL nodes.
Don't forget to test failover to ensure that SQL is working correctly on all nodes.
If you have configured SQL Network settings to use a different port then you might need to change that manually. But if that needs to be done, then it should come out in the testing phase..
Thank you,
Wally