Microsoft SQL Server 2019 Always-ON Availability Group

preview_player
Показать описание
How to Setup SQL Server 2019 Always ON AG Group on Windows 2019

Software's Used:
Microsoft SQL Server 2019
Microsoft Windows 2019
VMWare Workstation Pro 17
SSMS - SQL Server Management Studio
Рекомендации по теме
Комментарии
Автор

In my case, there are 2 main servers (instance1, instance2) that perform FCI configuration, for HA(active-passive) purposes.
I want, add 1 machine (instance3), desire to configure Always-ON Availability Group between server cluster (instance1, instance2) and machine (instance3).
how i do the above case.

ProductionDBA
Автор

Hi, can we add any IP on the listener? or you created it before setting up the AG?

DonDBA
Автор

Please help! Have success with your tutorial install failover cluster, but when I follow this tut, I cant connect to Db engine from Win19Dc, but when I install sql server, at step add current user, I click and it add auto user administrator, I must remove it, and add manual with user sqlsa! Please help, i dont know where my problem! Do I need open port sql server ?

thonghoang