Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a problem when I run my web project. I get this error :

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)

Then I found in SQL Server Configuration Manager that SQL Server Express stopped.
When I'm trying to run SQL Server Express, another error appears:

the request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details

When I open services.msc to start SQL Server (SQLEXPRESS instance) then this error happens:

Window could not start the sql server (SQLEXPRESS) on local Computer. For more information , review the System Evemt Log. If this is a non -Microsoft service,contact the service vendor, and refer to service-specific error code 3417

Any solution to solve my problem ???

The version is SQL Server 2008 R2 Express.

share|improve this question
1  
We need to see what the error is in the event log. –  Thomas Stringer May 24 '12 at 15:10
    
possible resolution? stackoverflow.com/questions/1617402/… However, as others have mentioned, the log will help determine what happened. –  swasheck May 24 '12 at 21:05

2 Answers 2

Open SQL Server configuration manager (start-->Run-->SQLServerManager10.msc) and try to start the service. If there is a problem starting the service, locate the SQL server Error log (in the SQL service configuration manager advanced tab there is a location or path of the error log) and post the output in the forum.

share|improve this answer

This usually occurs when the master.mdf or the mastlog.ldf gets corrupt . In order to solve the issue goto the following path C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL , there you will find a folder ” Template Data ” , copy the master.mdf and mastlog.ldf and replace it in C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Data folder . Thats it . Now start the MS SQL service and you are done

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.