question

TanmoyDas-9282 avatar image
0 Votes"
TanmoyDas-9282 asked TanmoyDas-9282 commented

SharePoint 2016 installation with Always on in SQL 2016

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?

office-sharepoint-server-administration
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any thought guys

0 Votes 0 ·

Any thought guys

0 Votes 0 ·

1 Answer

trevorseward avatar image
0 Votes"
trevorseward answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.