Unable to insert data connecting to clustername- Availabilty Group manual failover
We have Availability group Set up in our Dev environment ( SQL 2012 Developer Edition) . with 3 node (Node1, Node 2, Node3). Cluster name used is- SQLClust. I have set up availability group for a test database (Test). I can insert data to this database when Node 1 is the primary ie I'm using the cluster name to connect via management Studio, But when I failover the availabilitygroup to Node 2 I 'm getting the error when i run insert script. Failed to update database "Test" because the database is read-only. This error appears only when using the cluster name. But when i connect to Node2 usinf instance name i can insert data successfully. Node1- Role-Primary, AvailabilityMode-Synchronous, FailoverMode-Manual, Connections-AllowAllConnections, ReadableSecondary-yes Node2- Role-Secondary, AvailabilityMode-Synchronous, FailoverMode-Manual, Connections-AllowAllConnections, ReadableSecondary-yes Node3- Role-Secondary, AvailabilityMode-Asynchronous, FailoverMode-Manual, Connections-AllowAllConnections, ReadableSecondary-yes Any clues what could be the issue here.