Share via

SharePoint 2016 installation with Always on in SQL 2016

Tanmoy Das 806 Reputation points
2020-08-24T05:58:39.74+00:00

Hi,

I need to install SharePoint 2016 with SQL 2016 ( Always on )

1) Should I use a SQL alias with availability group?

2) If not, then should I use the link server name in availability group?

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,926 questions
Accepted answer
  1. Trevor Seward 11,701 Reputation points
    2020-08-24T15:15:12.943+00:00

    Do not use SQL Aliases with AOAG Listener endpoints. The purpose behind a SQL alias is database mobility, i.e. you need to move to a new SQL Server. AOAG resolves that as you can add or remove a SQL Server from the AOAG endpoint.

    You should be using the AOAG Listener endpoint.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.