[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SharePoint Services 3 Site has become Read Only

Posted on 2010-09-16
8
Medium Priority
?
962 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

656 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