?
Solved

SharePoint (WSS) Database Statistics Failed

Posted on 2011-10-20
7
Medium Priority
?
732 Views
Last Modified: 2012-05-12
I applied some SBS 2008 updates last night. Now we can see our SharePoint but we cannot make changes to it. We cannot restart the server before 2000 hrs today so I am looking for some help.

In SQL Server all databases have ReadOnly set to False
The Central Operations - Timer Job Status says that Database Statistics failed.

How can I restart this process? I assume that it is part of the stsadm command but I don't know what operation I would choose.

Your insight is greatly appreciated. Timer Job Status
0
Comment
Question by:LostInWindows
  • 5
  • 2
7 Comments
 
LVL 8

Expert Comment

by:npinfotech
ID: 37001793
Do you see anything in the server event logs related to the failure?
0
 
LVL 1

Author Comment

by:LostInWindows
ID: 37001933
I have an Event ID 3355
Cannot connect to SQL Server. np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query not found. Additional error information from SQL Server is included below.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding

I also have an Event ID 3760:
SQL Database 'SharePoint_AdminContent_d4e397f2-a27a-48a0-a628-d25db6672bab' on SQL Server instance 'EPICSERVER\Microsoft##SSEE' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_AdminContent_d4e397f2-a27a-48a0-a628-d25db6672bab" requested by the login. The login failed.
0
 
LVL 8

Expert Comment

by:npinfotech
ID: 37001998
looks like you have permissions issues.  Here is a link that describes how to verify and fix permissions issues for event id 3355 (might also take care of 3760):

http://technet.microsoft.com/en-us/library/cc561047(office.12).aspx
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Author Comment

by:LostInWindows
ID: 37003216
Sharepoint 3.0 operations, service account, Web application pool, Web Service: Windows SharePoint Services Web Application / Application Pool: SBS Sharepoint AppPool are running under the Network Service account.  

The ShareWebDb db_owner role contains the NETWORK SERVICE.  SQLServer Management Studio Express says Database Engine \\.\pipe\mssql$microsoft##ssee\sql\query database ShareWebDb owner role contains NT AUTHORITY\NETWORK SERVICE who is also in the Logins list.  

And the single site/content database:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>stsa
dm -o enumsites -url http://companyweb

<Sites Count="1">
  <Site Url="http://companyweb" Owner="EPIC\svradmin" ContentDatabase="ShareWebDb" StorageUsedMB="787.4" StorageWarningMB="0" StorageMaxMB="0" />
</Sites>

allowed me to create and delete a new quota template.  All good.

But even though Server Administrator is a Site Owner having Full Control, Editing tabs are not displayed.  Eg. Shared Documents only has an Actions tab (for viewing).  It's like I've been patched-out of my own security settings.



0
 
LVL 1

Author Comment

by:LostInWindows
ID: 37003465
And after bouncing the Sharepoint and ISS services my http 80 companyweb entry disappeared.  This happened after last month's patches as well and Microsoft tweaked and wizarded until it was better.  2 Months in a row now!
0
 
LVL 1

Accepted Solution

by:
LostInWindows earned 0 total points
ID: 37006240
I found my own solution through a fellow IT friend in town. I needed to make a change in Central Admin. The site had been auto-magically switched to read only.
0
 
LVL 1

Author Closing Comment

by:LostInWindows
ID: 37035256
I found my own solution through a fellow IT friend in town. I needed to make a change in Central Admin. The site had been auto-magically switched to read only.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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…
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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

840 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