Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability Group configuration. The details about error Microsoft SQL Server 976 that he was getting is given below. Cannot connect to...
I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was configuring Always On Availability Group again on this database server. We followed all processes but Listener was failed to create...
We have Alwayson Availability Group configuration for our SAP systems. We faced SAP connectivity issue when application team tried to do a failover/HA testing and connect to database post failover, they were failed to connect to the current primary replica...
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn is configured. SQL Server Error 15141 suggests that the login which i want to drop owns AlwaysON endpoints. Here we...
SQL Server Always On is just a term given by Microsoft for Availability Group & Failover Cluster Instances that are used to achieve HA, DR & Scale out solution. Always On Failover Cluster Instance is same which we call SQL...
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson Availability Group configuration, you find it showing in resolving state after Automatic failover of AOAG Configuration. Let us get the...
