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
Solved

SharePoint Services 3 Site has become Read Only

Posted on 2010-09-16
8
935 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
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: 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

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
sharepoint online 3 44
Sharepoint 2010 Auditing 4 35
Create Task List as an icon on Home Page 6 37
Masterpage unexpected error 7 35
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
I work for a company that primarily works with small businesses as their outsourced IT vendor. As such the majority of these customers utilize some version of Small Business Server. Due to the economics of running a small business, many of these cus…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 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