Forum Discussion

Sajithru's avatar
Sajithru
Level 2
10 years ago

SQL Server with Veritas HA

 

Hi All,

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?

  • Windows Server 2012 R2
  • SQL Server version 2012
  • Veritas Infoscale version 7

BR,

1 Reply

  • Hi Sajithru,

    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.

     

    Thank you,

    Wally