Solved

Sharepoint service can't run

Posted on 2006-07-01
13
1,613 Views
Last Modified: 2008-03-17
Hello,

My office runs SBS 2003, and recently we installed SP1 which crashed the server. It was now rebuilt using our backup but companyweb is down because the sharepoint service won't start. It comes up with the following error:

"The MSSQL$SHAREPOINT service on the local computer started then stopped. Some services stop automatically if they have no work to do, for example, the performance Logs and Alerts service."

Please what can i do to get sharepoint running again?
0
Comment
Question by:bethgurl
13 Comments
 
LVL 13

Expert Comment

by:itcoza
Comment Utility
Hi bethgurl,

Please check the system and application event log and report any errors or warnings found there.  This will help in getting this problem resolved.

Regards,
M
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
Comment Utility
When you say you installed SP1, was that the complete 5-part package that's required for SBS SP1?  (http://sbsurl.com/sp1)

Jeff
TechSoEasy
0
 
LVL 8

Expert Comment

by:dhoustonie
Comment Utility
What errors are appearing in the event logs? How old was the backup of the data you recovered from?

David
0
 

Author Comment

by:bethgurl
Comment Utility

The error which appears in the application log is as follows: "#50070: Unable to connect to the database STS_Config on MAIL\SharePoint.  Check the database connection information and make sure that the database server is running." This error came up just after the server crashed and had to be restored using our ASR and backup (which was done the morning of the upgrade).

Also when i try to access companyweb, i get the following error: "Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com." I have followed steps in the 823287 document but the problem still persists.

By the way, the first installation of the 5 part package required to upgade to SP1 was the one that crashed our server, so we could not complete the process. I'm quite new to server support and maintenance so i would appreciate any help i can get. Thanks...
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
Comment Utility
So, you've essentially restored to the point prior to beginning the SP1 installation?  I would suggest then that you remove the SharePoint Extensions and reapply them, that should fix your problem.

To remove, open SharePoint Central Administration (http://localhost:8081 on the server), under Virtual Server Configuration click Configure virtual server settings, select companyweb and then under Virtual Server Management, click Remove Windows SharePoint Services from virtual server, leave the setting at "Remove without deleting content databases" and click OK.

On the next screen to add them back, click Extend or Upgrade a virtual server.  Click companyweb, and then "Extend and map to another virtual server".  Change the Application Pool to "Use an existing application pool", and select DefaultAppPool (NT AUTHORITY\NETWORK SERVICE) and click OK.

Hopefully that should do the trick.  Please let me know if you encounter any problems.

Jeff
TechSoEasy


0
 

Author Comment

by:bethgurl
Comment Utility
Hello Jeff,

Yes the server has been restored to the point before beginning the SP1 installation. I just attempted to remove sharepoint extensions; i succeeded in getting to the "Remove without deleting databases" page but i get an error (Cannot connect to the configuration database. For tips on troubleshooting this error, search for article 823287 in the Microsoft Knowledge Base at http://support.microsoft.com) on the next page.

Sorry i forgot to mention that my superior re-installed the SQL server instance because SQLSERVER and SQLSHAREPOINT services weren't running. Now the SQLSERVER service is running but sharepoint still isn't.

Do you think we will need to rebuild the server from scatch?
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
Comment Utility
Was the MSSQL$SHAREPOINT instance upgraded to full SQL server from WMSDE?

If so, are the databases attached?  (Look in Enterprise Manager)

You shouldn't need to completely rebuild for this issue... it's just a configuration problem.

Jeff
TechSoEasy
0
 

Author Comment

by:bethgurl
Comment Utility
Hello Jeff,

"Was the MSSQL$SHAREPOINT instance upgraded to full SQL server from WMSDE?" - I am not quite sure how to go about this, can you please shed more light on it? Basically, what is WMSDE? And how do i go about upgrading the instance to full SQL Server?

"If so, are the databases attached?  (Look in Enterprise Manager)" - Looking at the databases in the Enterprise Manager, i have about six (6) databases in the Enterprise Manager MMC. How do i check which one of them is attached? Thanks alot....

0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
Comment Utility
How about following the steps in this KB and then letting us know if you run into any issues:

http://support.microsoft.com/kb/827701

Jeff
TechSoEasy
0
 

Author Comment

by:bethgurl
Comment Utility
Hello Jeff,

Thanks for your replies so far.
 http://support.microsoft.com/kb/827701 - This KB basically says a lot about restoring sharepoint and companyweb services from backups and backup configs.
Unfortunately, this does not help because the first step of the solution requires that companyweb be accessible. At this point, as i stated earlier, my companyweb is not accessible, MSSQL$Sharepoint and MSSQL$SBSMonitoring services do not start.

The files:
• STS_Config.mdf
• STS_Config_log.ldf
• STS_Servername_1.mdf
• STS_Servername_1_log.ldf
 that were stated in the KB have been searched for, but were not found on our server.

Any other ideas?
0
 
LVL 74

Expert Comment

by:Jeffrey Kane - TechSoEasy
Comment Utility
Those files need to come from your backup.  

It does require that your restore has a working http://companyweb, so if you don't have that, then you would need to reinstall it.  I probably should have given you this KB instead, sorry about that:  http://support.microsoft.com/kb/829113

Jeff
TechSoEasy
0
 

Author Comment

by:bethgurl
Comment Utility

Hello Jeff,

We could not reinstall the intranet component, the wizard comes up with an error saying the user has to be part of domain admins, schema admins and enterprise admins. Also SQL server service stopped running. My superior decided we should rebuild the server dues to other issues we have been facing alongside sharepoint not running.

Thanks...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
Comment Utility
Well, good luck.  You would have needed to have been logged in with the built-in Administrator account to perform any of this, by the way.

Jeff
TechSoEasy
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Small Business Server 2011. NOTE: This guide has been written using the preview version of SBS2011 therefore some of the screens may …
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now