Data Base in Read-only mode

MichaelHan-MSFT 18,016 Reputation points
2020-10-27T07:43:10.137+00:00

Hi All,

We created out new SharePoint 2019 Farm of 3 SharePoint Servers and 2 SQL Servers (Cluster). When I try to create a new web application I get an error:

Cannot update database on SQL Server instance '<servername>'. Database is read/only. Additional error information from SQL Server is included below. Failed to update database "SharePoint_AdminContent_<GUID>" because the database is read-only.

We checked but the data is not read-only and the status is (Synchronizing) as it should be. We have no idea what the problem is but we also get a warning on the Central Administration page saying:
We apologize for the inconvenience, but we've made OneDrive and sites read-only while we do some maintenance.

This is an on-premise farm and we have no connection to One Drive. I thought it's because the farm is in "maintenance mode" but we checked through PowerShell and it wasn't. Can anybody help please? Any help is highly appreciated.

Thank you

Source link from TechNet

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,809 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 41,941 Reputation points Microsoft Vendor
    2020-10-28T07:12:30.673+00:00

    Please follow below steps to troubleshooting the issue.

    1.Verify that the user account that is performing this procedure is a member of the db_owner fixed database role in each database.
    2.Start SQL Server Management Studio -> Right-click the content database that you want to make read-write -> Click Properties -> Select the Options page, in the Other options list, scroll to the State section -> In the Database Read-Only row, click the arrow next to True, select False, and then click OK.

    Reference:
    Failed to update database because the database is read-only

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments