SQL Server Error Msg 1466 – Database “%.*ls” is read-only on one of the server instances which is incompatible with participating in database mirroring or in an availability group. Set the database to read-write mode, and retry the operation.

In this blog post, let’s learn about the error message “1466 – Database “%.*ls” is read-only on one of the server instances which is incompatible with participating in database mirroring or in an availability group. Set the database to read-write mode, and retry the operation.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

1466 – Database “%.*ls” is read-only on one of the server instances which is incompatible with participating in database mirroring or in an availability group. Set the database to read-write mode, and retry the operation.

Reason for the Error

To be update soon…

Solution

To be update soon…