Database write protected after failover

103 Views Asked by At

We have a program that connects to our cluster-object to read and/or write in a database. When connecting while our primary server is active, it works without issues. When I do a failover and try to connect, I get Error while updating Database XY, the database is write protected.

Both servers have identical users and permissions, which I transferred with this stored procedure provided by Microsoft

The Availability Group is configured like this: Availability Group Configuration

The databases have the same users mapped with the same permissions, therefore it is unlikely to be the issue.

I do not know what is causing this.

Thanks in advance.

1

There are 1 best solutions below

0
SikorskyS60 On BEST ANSWER

Okay, I found out what was wrong:

Our program should have been pointing at the group listener and not the cluster object, because the cluster object points only at the first replica server in it's cluster. That's why after the failover all the databases were write protected.