Solution for SQL Server Alwayson to add listener failure, alwayson listener

Solution for SQL Server Alwayson to add listener failure, alwayson listener

I. Error description

1. The cluster service fails to bring the cluster service or application "Alwayson22" online or offline. One or more resources may fail. This may affect the availability of cluster services or applications.

2. Cluster Resource "Listen25" or application "Alwayson22" in cluster service failed/listener addition failed

Ii. Handling Methods

You can obtain the problem from the error message. When you confirm that the cluster has been started, DNS, and domain services are normal. Yes, the cluster service has a problem. From the error, we can see that "the cluster network name is not online". Opening the cluster core resources finds that the cluster is offline and the node is normal.

1. Bring the resource online

2. More operations-repair active directory objects

Note:If the cluster resources cannot be brought online in step 1, use the solution in step 2.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.