SBS2003 - MSSQL$sharepoint service starts then stops

After a reboot this weekend the MSSQL$sharepoint service starts then stops, but I cannot get it stable. I keep getting the following error in the event log:

Event Type:      Error
Event Source:      Windows SharePoint Services 2.0
Event Category:      None
Event ID:      1000
Date:            4/19/2010
Time:            11:31:04 AM
User:            N/A
Computer:      SBS2003
Description:
#50070: Unable to connect to the database STS_Config on SBS2003\SharePoint.  Check the database connection information and make sure that the database server is running.

I have researched the problem and have found numerous fixes that do not work. I have already tried the following fix:
http://support.microsoft.com/?id=840685

I am running SQL Server 2005 Express. Someone please help me get this service started

I believe this could be a problem:
2010-04-19 10:06:27.07 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)

2010-04-19 10:06:33.45 spid4     Database 'master' has invalid schema.
etcsAsked:
Who is Participating?
 
etcsConnect With a Mentor Author Commented:
I was able to get the companyWeb installed by following this article.
http://support.microsoft.com/kb/829114

I then was able to restore the contents of my old companyWeb by following this article
http://support.microsoft.com/kb/829113/
0
 
etcsAuthor Commented:
The correct solution seems to be on this link:
http://blogs.technet.com/sbs/archive/2008/07/11/cannot-access-company-web-after-installing-948110.aspx

However, I am not sure what they are expecting in step 1. Will someone please explain?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Shreedhar EtteCommented:
Step 1 say to install the SQL 2000
0
 
etcsAuthor Commented:
I understand, but where is the file it's asking for? I have my sbs2003 disc inserted, but I don't see any place to reisntall SQL from it.
0
 
Shreedhar EtteCommented:
Browse the disk there will folder MSDE.
0
 
etcsAuthor Commented:
I keep getting errors when trying to reinstall the MSSQL$sharepoint.

Attached are images of the errors I am receiving.
Capture.PNG
Capture1.PNG
0
 
etcsAuthor Commented:
Now that I have the companyWeb online and the MSSQL$sharepoint service started, I am unable to authenticate to the companyweb. It keeps prompting for credentials even when I put in correct credentials.
I was able to get on the configuration page through the sharepoint central administration page, but I got the following message when trying to access it:
"The virtual server that is referenced here is not in the config database."

From what I could gather, I need to extend the virtual server. When I access the central administration - > Extend an existing virtual server from the Virtual Server List page -> company web is not listed as a server. When I click on the complete list of servers and then click on companyweb it just takes me to the configuration page and not the extend page.

Please help!
0
 
etcsAuthor Commented:
I am also getting this error in the event log
Event Type:      Error
Event Source:      W3SVC
Event Category:      None
Event ID:      1007
Date:            4/20/2010
Time:            5:27:51 PM
User:            N/A
Computer:      SBS2003
Description:
Cannot register the URL prefix 'http://companyweb:80:192.168.1.7/' for site '4'. The necessary network binding may already be in use. The site has been deactivated.  The data field contains the error number.


0
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.

All Courses

From novice to tech pro — start learning today.