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?
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?
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.
1 Person is following this question.