Solved

SharePoint Services 3 Site has become Read Only

Posted on 2010-09-16
8
947 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

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

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

728 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