question

MichaelHan-MSFT avatar image
0 Votes"
MichaelHan-MSFT asked EmilyDu-MSFT edited

Data Base in Read-only mode

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


office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT edited

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.




5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.