asked on

MSDE Databases will not start in SBS 2003

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.

venk_r

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.

ITGhost

ASKER

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

venk_r

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.

ITGhost

ASKER

Anyone else have any ideas?

ASKER CERTIFIED SOLUTION

ITGhost

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ITGhost

ASKER

This was the actual solution.