The request failed or the service did not respond in a timely fashion in sql server 2008 R2

Question

I am not able to start sql server 2008 R2 service . I cross checked all answers given here for same problem without any success. I disabled VIA protocal, still it didnot start. I tried using all options(local system, local server, network service) for login, but still nothing happened. I have SQL Server 2008 also installed and that is working fine without any problems. R2 was working fine , but due to unknown reasons it is not.

I can't uninstall as I can't loose databases mounted in it.

Solution 1

Have you checked the credential used to start the service? You may have changed password or permissions for that specific user.

To check this settings, open the Service panel (services.msc), go to the SQL Server Service named as your Instance (ex. SQL Server (MSSQLSERVER) ), doubleclick and go to the Connection tab. Check the authentication you provided there is valid, and that the user has all the permissions needed to start and stop the instance, or try a different user.

If you are the administrator of the machine, "Local System Account" should be enough to start/stop the service.

Otherwise, please follow the link down here and check in the Event Viewer which error is provided there. If it's different from the one described in the article, give us yours. This could help us help you ;)

source: http://blog.sqlauthority.com/2011/03/29/sql-server-fix-error-the-request-failed-or-the-service-did-not-respond-in-timely-fashion-consult-the-event-log-or-other-applicable-error-logs-for-details/

Solution 2

Step 1 - Check credentials for service

Step 2 - Check event viewer and look for error messages it sends. It should be found in Windows Logs -> Application

Once you see any log events with errors or warnings when trying to start the service, please update the question/thread so we can see and help you troubleshoot from that point.

Thanks, Matt

Comments

[dean]

How do you detach a database from non-functional instance? I agree, though, that he won't lose the databases if he copy the files and attach, but he will lose some data.

[ubaid ashraf]

@dean Data loss is not issue, but I am afraid , i may loose database which i cant afford

[dean]

OK then, what's stopping you to copy the data files to some other instance and try attaching them with sp_attach_single_file?

[Registered User]

I just tested creating a database, turning off sql server, copying the files, and attaching to another server without any problems. This is no different than when I had a complete melt down of the hardware for a server a few years ago and I had to attach databases from our SAN to a new instance and server. You should be able to attach the databases to a new instance without a problem.