Database write protected after failover
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:
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.
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.
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
- output sql data to html with hyperlink
- Update all column names to be lowercase
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Query to get only numbers from a string
- SQL grouping result to half hour
- table is specified twice both as a target for INSERT and as separate source of data
- SQL to JSON Need Bracket for Array that can have multiple rows
- Find all occurrences of Substring and replace it with a special characters
- Oracle Merge statement 'ON' vs 'UPDATE' conditions performance on target table
- How to do aggregate raw sql with julian date in sqlite (with django)
- SQL Merge SOURCE order and OUTPUT order
- Notepad++/Eclipse sql code auto-indent option?
- Output of update statement does not show correct row number
- Map table to exactly one of three
- PostgreSQL - ERROR: column does not exist SQL state: 42703
- How to force evaluation of subquery before joining / pushing down to foreign server
- SQL SELECT TOP 1 FOR EACH GROUP
- Convert a date to timestamp in a join with interpolation
- How To CAST substring as a DATE
- batch update a column using sql
- Firebird SQL add empty rows in resultset
- How do I cast a timestamp column as a MM/DD/YYYY in BigQuery
- Parsing JSON with Oracle SQL without knowing incoming field names
- Selecting from random column in PL/SQL
- Simple Query to Grab Max Value for each ID
- How to programmatically check if row is deletable?