[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

MSDE Databases will not start in SBS 2003

Posted on 2011-09-22
6
Medium Priority
?
1,103 Views
Last Modified: 2012-05-12
I have a Windows SBS 2003 server. The three MSDE instances (MSSQL$MSFW, MSSQL$SBSMONITORING, and MSSQL$SHAREPOINT) will no longer start.  This first occurred after a recent restart of the server for a hardware replacement.  When attempting to start any of these services, I receive the message "Error 1053: The service did not respond to the start or control request in a timely fashion." The System log has two events logged when this occurs (7009 and 7000); the 7000 event give the same error as above, but the 7009 says "Timeout waiting for the service to connect."  Also,the application log has event 1000 for the Windows Sharepoint Service:"Unable to connect to the database STS_Config on Servername\Sharepoint"

When I attempt to connect to the databases in Management Studio, I receive

Cannot connect to SERVER\MSFW.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I was able to get the server functioning to some degree by changing the logging options in ISA 2004 to flat file and removing the dependency of the Windows Firewall service on the the MSSQL$MSFW instance; however this is not the solution I need.

Thanks.
0
Comment
Question by:ITGhost
[X]
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
  • 4
  • 2
6 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36580728
Check 2 things initially
1.TCP IP Enabled
2.Check the SQL Service account
If you are not using a domain account as a service account (for example if you are using NETWORK SERVICE), you may want to switch this first before proceeding.

Note: Try to move to the SQL Express version if possible . As MSDE are old versions and they have more limitations.

0
 
LVL 1

Author Comment

by:ITGhost
ID: 36583380
Okay, TCP IP is enabled.  The SQL instances are using a local administrator account.  I guess I don't know what you mean in the last part "Try to move the SQL Express version if possible."
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36583514
Well , that may be bit out of context actually. I was saying it would be good to migrate to the SQL Express edition of SQL Server at some point.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:ITGhost
ID: 36600220
Anyone else have any ideas?
0
 
LVL 1

Accepted Solution

by:
ITGhost earned 0 total points
ID: 36600910
Found that MSVCP71.dll was missing. Copied from working 2003 server.
0
 
LVL 1

Author Closing Comment

by:ITGhost
ID: 36895875
This was the actual solution.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

650 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