Once you have completed the script you can go to the Cluster Administrator by going to Start Menu -> Run
and paste this cluadmin.exe
or by going into the control Panel -> administrative Tools -> Cluster Administrator.
Then Under Groups find the name of the SQL Server Group. Right Click on SQL Server -> Properties:
Under Properties [General] tab check that you have the name of your Clusters node on the Posible Owners section
. That means that SQL Server can run on all the nodes listed in there. You can also try to fail SQL from the active node to another node and make sure that it successfully runs.
Take a look at the attached image.
if you have more questions, please feel free to reply to this posting.
- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809