Delphix with SQL 2014 Avaialbility groups

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

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.
Photo of Bhanu Naidu

Bhanu Naidu

  • 110 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Darin Tully

Darin Tully, SQL DBA

  • 530 Points 500 badge 2x thumb
Official Response
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.