Friday 14 April 2017

SQL Server 2016- Error:- User is unable to connect Listener after failover Availability Group(AG) in AlwaysON



Cause:- It means User is created on only one SQL server which was Primary and after  doing failover Primary become secondary so now user will not able to connect Listener. 



Resolution :- User must be created on both SQL servers. Create SQL Server user in both side SQL servers. Issue will resolve.


No comments:

Post a Comment