Tips to work with SQL Server 2017 clustering You should proper configure the SQL Server 2017 service accounts. Ensure that each SQL Server 2017 service account is a domain account and a member of the Local Administrators group of each cluster node and a member of the Domain Users group. Set the SQL Server 2017 service accounts passwords to be...
Tag: AlwaysOn
Troubleshooting problems with AlwaysOn availability group in SQL Server 2016
Troubleshooting problems with AlwaysOn availability group in SQL Server 2016 If you have problems with AlwaysOn availability group in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 AlwaysOn availability group’s bugs were fixed in SQL Server service packs, you should install the latest...