?
Solved

SharePoint Services 3 Site has become Read Only

Posted on 2010-09-16
8
Medium Priority
?
953 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 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