Solved

SharePoint Services 3 Site has become Read Only

Posted on 2010-09-16
8
919 Views
Last Modified: 2016-05-20
We run SBS 2008, last night I applied the following updates via WSUS:
KB981322, KB2347290, KB890830, KB981550, KB2141007, KB2124261.

There were no errors during the update process, the server restarted normally and all services appeared available following the reboot.

Today our entire Windows SharePoint Services 3 site at http://companyweb is read only to all users, including the domain and companyweb administrator.

All sections of the site are accessible but no content can be added or changed. Office documents open as read only, shared OneNote Notebooks stored in document libraries fail to sync, the option to upload new files to a document library is not visible.

All site permissions appear correct.

Something which seems strange and may be related. If I open SQL Management Studio Express (as administrator) and connect to "\\.\pipe\mssql$microsoft##ssee\sql\query" I cannot view the properties of the WSS_Content database, I recieve the error attached below.

We use SharePoint extensively so this is pretty important to us, thanks.
WSS-Content-error.PNG
0
Comment
Question by:siht
  • 5
  • 3
8 Comments
 
LVL 8

Expert Comment

by:epohl
ID: 33693686
Tried running The SharePoint Products and Technologies Configuration Wizard again?
0
 
LVL 6

Author Comment

by:siht
ID: 33693749
Thanks epohl, that was the first thing I did. It completed successfuly but did not resolve this issue.
0
 
LVL 8

Expert Comment

by:epohl
ID: 33693820
Anything in the application event logs as to why the database may have been changed to read only?
0
 
LVL 6

Author Comment

by:siht
ID: 33693930
There are a couple of these:
*************************************************************
Source :ASP.NET 2.0.50727.0
Event ID: 1309

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 16/09/2010 9:50:05 PM
Event time (UTC): 16/09/2010 1:50:05 PM
Event ID: 7844133991af4eac8927df66da2a803f
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/4/ROOT-1-129291186053587005
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\inetpub\OldCompanyWeb\
    Machine name: SPECSERVER
 
Process information:
    Process ID: 5420
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: COMException
    Exception message: Access is denied.
 
 
Request information:
    Request URL: http://oldcompanyweb/_vti_bin/sitedata.asmx 
    Request path: /_vti_bin/sitedata.asmx
    User host address: 192.168.3.3
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 4
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
   at System.DirectoryServices.DirectoryEntry.Bind()
   at System.DirectoryServices.DirectoryEntry.get_IsContainer()
   at System.DirectoryServices.DirectoryEntries.ChildEnumerator..ctor(DirectoryEntry container)
   at System.DirectoryServices.DirectoryEntries.GetEnumerator()
   at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.System.Web.IHttpModule.Init(HttpApplication app)
   at System.Web.HttpApplication.InitModulesCommon()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
   at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 
 
Custom event details:
*************************************************************

Which looks promising but I have not found a resolution yet. I'm looking at it as we speak.

There are also a few of these:

*************************************************************
Source: SQLBrowser
Event ID: 3

The configuration of the AdminConnection\TCP protocol in the SQL instance MICROSOFT##SSEE is not valid.
*************************************************************

 


0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 6

Author Comment

by:siht
ID: 33693972
Also a couple more ASP.NET errors, similar to the others:
*************************************************************
Source :ASP.NET 2.0.50727.0
Event ID: 1309

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 16/09/2010 9:50:05 PM
Event time (UTC): 16/09/2010 1:50:05 PM
Event ID: 3392bcf358f74e23816a33ac69af0144
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/799145558/ROOT-1-129291186047835420
    Trust level: WSS_Minimal
    Application Virtual Path: /
    Application Path: C:\Program Files\Windows Small Business Server\Bin\WebApp\InternalWebSite\
    Machine name: SPECSERVER
 
Process information:
    Process ID: 4320
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: COMException
    Exception message: Access is denied.
 
 
Request information:
    Request URL: https://remote.specterra.com.au:987/_vti_bin/sitedata.asmx 
    Request path: /_vti_bin/sitedata.asmx
    User host address: 192.168.3.3
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 4
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)
   at System.DirectoryServices.DirectoryEntry.Bind()
   at System.DirectoryServices.DirectoryEntry.get_IsContainer()
   at System.DirectoryServices.DirectoryEntries.ChildEnumerator..ctor(DirectoryEntry container)
   at System.DirectoryServices.DirectoryEntries.GetEnumerator()
   at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.System.Web.IHttpModule.Init(HttpApplication app)
   at System.Web.HttpApplication.InitModulesCommon()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
   at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
 
 
Custom event details:
0
 
LVL 8

Expert Comment

by:epohl
ID: 33695984
Tried uninstalling the update and seeing if it makes a difference?
0
 
LVL 6

Author Comment

by:siht
ID: 33697146
I have uninstalled KB2141007 as it seemed th most likely to have caused this but that did nothong to resolve the issue.
0
 
LVL 6

Accepted Solution

by:
siht earned 0 total points
ID: 33697562
Resolved.

It seems something had "locked" our SharePoint site, I am not sure what.
Running the following command as administrator on the SBS server restored full functionality to the site:

stsadm –o setsitelock –url http://companyweb –lock none

Thanks for your input epohl.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Redesign the sharepoint site. 9 51
JSOM: The collection has not been initialized. 5 46
Windows 10 VPN? 6 73
Initialize SharePoint Online List Values in Quick Edit 7 21
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now