05-13-2016 12:56 AM
I am configuring SQL Cluster using VERITAS HA and DR replication using VVR,
I have configured the cluster and storage as per the cluster implimentation document with same sql instance installations but in SQL Server agent configuration wizard it gives an error stating there are no instances available to configure.
can someone help me with a solution for the issue I'm facing?
05-31-2016 11:56 AM
Are you still having this issue?
If so, you can check the SQL wizard log that is located in the %vcs_home%\log folder. It might provide some more details on what it is finding or not finding.
For a more direct approach, you can run the following command on the cluster nodes:
hadiscover -discoverall SQLServer
You might want to dump that to a text file on each server and compare them. I would check the path to master.mdb file in the output and make sure that it is pointing to the shared storage. Other than that, compare the SQL instance name on each server and make sure that there is not already a service group in the cluster for that instance name.