SQL Server Availability Groups dSources

  • 0
  • 1
  • Problem
  • Updated 2 months ago
  • Solved
I can't get this forward, anyone have a working SQL Server Availability Group dSource?
Photo of Alfredo Cerrillo

Alfredo Cerrillo

  • 130 Points 100 badge 2x thumb
  • frustrates

Posted 2 months ago

  • 0
  • 1
Photo of MichaelT

MichaelT, Official Rep

  • 892 Points 500 badge 2x thumb
Hi Alfredo,
Have you provided the permissions necessary on the following views? The Delphix Database users must have VIEW ANY DEFINITION and VIEW SERVER STATE on both the host and the source.

 https://docs.delphix.com/docs/delphix-administration/sql-server-environments-and-data-sources/settin...

If you have and continue to run into this issue, please do open a support ticket. We will get to the bottom of this.

Thank you,
Michael
Photo of Alfredo Cerrillo

Alfredo Cerrillo

  • 130 Points 100 badge 2x thumb
Official Response
Hi Michael, I already managed to register the AG.  In the end, the problem was taht the port 445 was closed for the cluster IP address.
Photo of MichaelT

MichaelT, Official Rep

  • 892 Points 500 badge 2x thumb
Great news, thank you for the follow up, sir!