MSSQL$Sharepoint service is Stopped -- AGAIN !?

Posted on 2009-07-02
Medium Priority
Last Modified: 2012-05-07
A little over a month ago, my SBS 2003 server was unable to start the Sharepoint services. Based on the responses from this forum, I followed the recommendation to de-install and re-install Sharepoint services, apply all the patches, etc.  It was working fine from May 31 until yesterday.  Suddenly, at 8:04 am, the MSSQL$Sharepoint service stopped and everytime I try to start it, it generates the same database error as it was a month ago.  I get the floowing error every 5 seconds (again). Why would this error suddenly return ?   We're not really using any Sharepoint services features, so would I be safe just deinstalling Sharepoint Services and not reinstalling ?

Event Type:      Error
Event Source:      Windows SharePoint Services 2.0
Event Category:      None
Event ID:      1000
Date:            7/2/2009
Time:            9:55:51 AM
User:            N/A
Computer:      xyzSERVER
#50070: Unable to connect to the database STS_Config on xyzSERVER\SharePoint.  Check the database connection information and make sure that the database server is running.

Question by:adladladl
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24773382
can you post the ERRORLOG file of your sql server instance?
it should be in the LOG folder of that named instance software folder.

Accepted Solution

adladladl earned 0 total points
ID: 24787599
I already :un-installed" SHarepoint services 'cause I was getting tired of all the errors being logged so the ERRORLOG is gone.
But, last time I had this error, this was the contents of the ERRORLOG:

2009-03-11 21:46:54.68 server    Microsoft SQL Server  2000 - 8.00.2055 (Intel X86)
 Dec 16 2008 19:46:53
 Copyright (c) 1988-2003 Microsoft Corporation
 Desktop Engine (Windows) on Windows NT 5.2 (Build 3790: Service Pack 1)
2009-03-11 21:46:54.68 server    Copyright (C) 1988-2002 Microsoft Corporation.
2009-03-11 21:46:54.68 server    All rights reserved.
2009-03-11 21:46:54.68 server    Server Process ID is 7780.
2009-03-11 21:46:54.68 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\LOG\ERRORLOG'.
2009-03-11 21:46:54.81 server    SQL Server is starting at priority class 'normal'(4 CPUs detected).
2009-03-11 21:46:55.04 server    SQL Server configured for thread mode processing.
2009-03-11 21:46:55.04 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2009-03-11 21:46:55.10 spid3     Starting up database 'master'.
2009-03-11 21:46:58.00 spid3     0 transactions rolled back in database 'master' (1).
2009-03-11 21:46:58.00 spid3     Recovery is checkpointing database 'master' (1)
2009-03-11 21:46:59.48 server    Using 'SSNETLIB.DLL' version '8.0.2039'.
2009-03-11 21:46:59.48 spid5     Starting up database 'model'.
2009-03-11 21:46:59.64 spid3     Server name is 'xyzSERVER\SHAREPOINT'.
2009-03-11 21:46:59.64 spid3     Skipping startup of clean database id 4
2009-03-11 21:46:59.64 spid3     Skipping startup of clean database id 5
2009-03-11 21:46:59.64 spid3     Skipping startup of clean database id 6
2009-03-11 21:46:59.64 spid3     Skipping startup of clean database id 7
2009-03-11 21:47:01.26 server    SQL server listening on Shared Memory.
2009-03-11 21:47:01.26 server    SQL Server is ready for client connections
2009-03-11 21:47:01.42 spid5     Clearing tempdb database.
2009-03-11 21:47:03.42 spid5     Starting up database 'tempdb'.
2009-03-11 21:47:03.76 spid3     Recovery complete.
2009-03-11 21:47:04.34 spid3     Cannot validate object 'master'.'dbo'.'sp_ActiveDirectory_Obj'.
2009-03-11 21:47:04.35 spid3     Database 'master' has invalid schema.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

624 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