I have a 2 node AlwaysON Ag setup,both in same subnet.
I have two application servers that connect to the database using the listener name.
The problem is, when the node1 is primary both the application servers are connecting to the database without issues,but when I peform the failover only one of the application server is connecting and the other application server says,cannot update the database as it is readonly.
All the users and logins are exactly same with SID on both the nodes.
Databases are in sync on both the nodes.
Listener name and IP lookup is also fine.
Any help is appreciated.