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

Kate 1 Reputation point
2021-11-23T12:11:17.92+00:00

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,713 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,799 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yi Lu_MSFT 17,456 Reputation points
    2021-11-24T08:37:42.753+00:00

    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