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