Skip to main content

All Questions

Filter by
Sorted by
Tagged with
0 votes
2 answers
784 views

Can I change the password of the domain account which I used to create the failover cluster?

Can I change the password of the domain account which I used to create the failover cluster? Will it affect the cluster at all? I have also created the Always On availability groups using that domain ...
user avatar
0 votes
2 answers
1k views

SQL Server 2019 DAG WFC - Manual Failover won't work (MSSQL Error 41131)

We set up a distributed failover cluster with 2 Windows Server 2019 Datacenter nodes, each of them running SQL Server 2019 Enterprise + SSMS18. The two nodes are located in two different sites with ...
DevDino's user avatar
0 votes
1 answer
732 views

How to check whether or not dynamic quorum and dynamic witness is enabled on WSFC?

Dynamic quorum and dynamic witness are abilities of the WSFC to dynamically adjust the vote of the nodes and witness to prevent unnecessary failovers. Where can I check whether the WSFC configuration ...
variable's user avatar
  • 3,489
-1 votes
4 answers
3k views

DNN Listener resolving to a secondary server in WSFC & AO AG

I have an Azure AO AG which consists of three servers (all WS-2019 & SQL-2019 CU8): A - Subnet 1 - Principal Server (Sync) B - Subnet 1 - Secondary Server (Sync) C - Subnet 2 - Secondary Server (...
Lickrob's user avatar
  • 84
0 votes
2 answers
2k views

SQL Server 2019 Always On using Distributed Network Name

We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
NorthFork's user avatar
  • 101