VNN vs. cluster name for source

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi, I've been going through the documentation for adding a MS SQL AG cluster as a source. The doco says to use the 'cluster' name. I have a feeling they may mean the VNN. Can anyone steer me straight on this? generally the cluster name is something that really only the WFSC cluster uses, and the VNN is the name that everyone uses(for instance, if you have sqlguyA and sqlguyB, your cluster name might be sqlguy_clst, and your VNN might be 'sqlguy'. Users would connect to 'sqlguy'; that being the VNN.
Photo of Kevin Tunge

Kevin Tunge

  • 122 Points 100 badge 2x thumb
  • uncertain

Posted 2 years ago

  • 0
  • 1
Photo of Darin Tully

Darin Tully, SQL DBA

  • 530 Points 500 badge 2x thumb
Official Response
Hi Kevin,

The documentation is correct. When adding an AG cluster, you do use the cluster name and not the VNN to add the environment. Once the environment is added, the Delphix Engine will list all of the AGs, that have Listeners, that are running on the SQL instances on that cluster.

So for example, if you had two SQL instances running in the cluster and both had AGs with Listeners, both SQL instances would be listed in the GUI. Or. if you had just once clustered SQL instance with two AGs, both of those would be listed.

Hope that helps!
-darin