Lakshman3787 avatar image
Lakshman3787 asked

Always on availability failover for SharePoint farm is failing to connect in SQL Server

We have SharePoint farm in front end 2013. We are using sql server 2014 enterprise edition . Initially, SharePoint farm is connected to Server A. But we wanted to configure Always On availability for this. We configured it from Sql end.Server B is the secondary replica. And we have configured the listener also. After configuring the listener we have given the listener name and IP to SharePoint team. They have changed alias name to Listner name in client connection side. After that we have done possible scenarios to test the failover. But, the failover scenarios got failed. We have observed one common issue in all the scenarios. After failing over to Server B, SharePoint is not redirecting to Server B, it is still trying to connect to Server A only. When we down the Server A, SharePoint also is going down. When we failed over to Server B ( primary )and Server A is available and acts as readable secondary. At this point of time SharePoint website is in readable state. Here, the observation is that SharePoint farm is only depending on Server A state. We have requested the SharePoint team to forget about always on and listener and try to connect to Server B directly. They have changed some settings in cliconfg.exe . **After that, the SharePoint is again trying to access the Server A only. What could be the reason for this? Is there any other team to be involved in this to resolve this issue , apart from SQL and SharePoint.** Quorum is configured as Witness File Share. we only have 2 replicas, When server A is down , the quorum is configured between File share and Server B . However, The Cluster is working fine, when we check the failover cluster manager immediately after Server A went down. FS witness is not placed on either on Server A side or server B side. It is placed on Another Server.
sqlserversql server 2014sharepointfailoverhigh-availability
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rvsc49 avatar image rvsc49 commented ·
Can you ensure that all the connection strings for the SharePoint farm are pointed to the Listener and the Listener only?
0 Likes 0 ·

0 Answers


Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.