How to configure an existing SharePoint 2019 to use SQL Always on Availability Group Listeners

Kate 1 Reputation point

Hi everyone

I have a situation where i have fully provisioned and operational SharePoint 2019 farm that was configured using the configuration wizard BUT for a single SQL server instance. We have since had DBA's add the SharePoint databases to a formal HA Always on Availability Groups AOAG with Listener. I seek advice on how i re-configure SharePoint 2019 to use this set up by using the Listener.

I have been assured that the SQL and AOAG side of things is working but cannot test it until I set up SharePoint 2019 to use it. I assume it is not just going into Central Admin and just changing the default SQL Server details not is it about re-running the Configuration Wizard?

I would greatly appreciate any advice on this.

Thanks in advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,259 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,761 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yi Lu_MSFT 17,366 Reputation points

    Hi @Kate
    As the lack of the same environment, I would suggest you to open a ticket with Microsoft for furthur help.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments