| Event Id | 4971 |
| Source | Windows SharePoint Services 3 |
| Description | Cannot update database on SQL Server instance '%1'. Database is read/only. Additional error information from SQL Server is included below. %2 |
| Event Information | According to Microsoft : Cause : This event is logged when SQL server database cannot update the database instance server. Resolution : Change database to Read / Write You must have db_owner access to the database to perform this action. To increase the size of the database 1.In SQL Server Management Suite, open the server node, right-click the database, and then click Properties. The database name is provided in the event message. 2.On the Properties dialog box, on the left navigation pane, click Files. 3.The Enable Autogrowth check box must be selected to make any changes. 4.In the Database files box, in the Autogrowth column, click the ellipsis for the database file. 5.In the Change Autogrowth dialog box, under Maximum File Size, if the Restricted File Growth option is selected, increase the maximum file size in the box to the right. You can also configure the database to grow without restrictions by selecting the Unrestricted File Growth option. 6.Click OK. Verify : You must be a member of the SharePoint Administrators group to perform this task. To ensure that any database issues have been resolved 1.Use the command Stsadm.exe -o enumsites to list the sites for each Web application to list all sites in the various databases, and locate one site in each database. 2.Browse to that site, and ensure that the appropriate page rendered. If you get an access denied page with an option to request access, or the option to sign in as a different user, the operation completed successfully. 3.In Central Administration, on the left-hand navigation pane, click Application Management. 4.On the Application Management page, in the SharePoint Site Management section, click Quota templates. 5.On the Quota Templates page, create a new quota template. The specific settings are not relevant to this verification test. You are creating the template to see if it can be accessed in step 7. 6.Click OK to save the quota template. 7.Refresh the browser window, and then return to the quota templates page. If the quota template that you created can be selected, then access to the Windows SharePoint Services 3.0 Configuration database has been restored. 8.Click Delete to delete the quota template. |
| Reference Links | Event ID 4971 from Source Windows SharePoint Services 3 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.