Delphix Products

Expand all | Collapse all

Delphix with SQL 2014 Avaialbility groups

Jump to Best Answer
  • 1.  Delphix with SQL 2014 Avaialbility groups

    Posted 10-06-2016 06:28:00 PM
    Hi,

    I am having trouble with Adding one of the SQL 2014 AG cluster with Delphix.

    This what I did so far.

    Added the windows cluster where SQL 2014 AG resided as source environment.  I already have PPT server registered as target environment.

    Now I go and add a dsource,  IDelphix engine somehow not displaying the database names in AG.


  • 2.  RE: Delphix with SQL 2014 Avaialbility groups
    Best Answer

    Posted 10-06-2016 09:03:00 PM
    Hi Bhanu,

    If the databases are not listed in the AG, one reason could be the AG does not have a listener. And another reason could be the AG was added as a stand-alone Source environment and was not added as a Clustered Source environment. If the AG was added correctly, there should be a "Clustered Nodes" section on the Environment Details tab for the AG environment.


  • 3.  RE: Delphix with SQL 2014 Avaialbility groups

    Posted 10-07-2016 06:08:00 AM
    Check also if the accounts used by your Delphix Engine and Staging server have VIEW ANY DEFINITION and VIEW SERVER STATE privileges (or, finer, VIEW DEFINITION ON AVAILABILITY GROUP::[agname]).


  • 4.  RE: Delphix with SQL 2014 Avaialbility groups

    Posted 10-07-2016 10:19:00 PM
    Thank you Both. These are the step I followed for setting up AG

    1. Set up listener
    2. Granted admin access to Account used on both Delphic engine and PPT 

    In my case,  There was an issue with reverse look up entry in windows cluster.  We corrected it and now able to register databases which are in AG.

    Thanks again to both of you.