The request failed or the service did not respond in a timely fashion?

Question

I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication.

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

Is anybody tell me why i am getting this error, whereas my SQL Server is running under network service built in a/c????

I googled it but not getting solution..

Thanks

Solution 1

Above mentioned issue happened in my local system. Check in sql server configuration manager.
Step 1:
SQL server Network configuration
step 2:

• Protocols for local server name
• Protocol name VIA Disabled or not..
• if not disabled , disable and check

.. after I made changes the sql server browser started working

Solution 2

Had the same problem, I fixed it.

1. Open SQL Server Configuration manager
2. Click on the SQL Server Services (on the left)
3. Double-click on the SQL Server Instance that I wanted to start
4. Select the Built-in account radio button in the Log On tab and choose Local system from the dropdown menu
5. Click apply at the bottom, then right click the instance and select Start

Solution 3

This really works - i had verified lot of sites and finally got the answer.

This may 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_50.MSSQLSERVER\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_50.MSSQLSERVER\MSSQL\DATA folder .

That's it. Now start the MS SQL service and you are done.

Solution 4

If you are running SQL Server in a local environment and not over a TCP/IP connection. Go to Protocols under SQL Server Configuration Manager, Properties, and disable TCP/IP. Once this is done then the error message will go away when restarting the service.

Solution 5

If you recently changed the password associated with the service account:

1. Start SQL Server Configuration Manager.
2. Select SQL Server Services in the left pane.
3. Right click the service you are trying to start in the right pane and click Properties.
4. Enter the new Password and Confirm password.

View more solutions

Comments

[emcor]

I do not see a "VIA" protocol option (SQL server 2014).

[moksef]

After using these methods (in this page), I restart my computer, then it works.

[moni123]

There are master.mdf and mastlog.ldf. these two files. Then, what I need to do ? my friend

[hamid]

best solution. tnx

[Verena Haunschmid]

Omg, that's a stupid mistake. I changed my windows password and then it stopped working (but I didn't notice right away). Your answer helped me figure that out, I just needed to change the password for my Built-in account.

[SEarle1986]

This worked. As above, a recent AD password change had caused the service to stop

[Nakres]

worked. if your website is still giving an error go to IIS select your website under sites then click stop and start from right section. that's what i did for my dnndev.me website.

[rayray]

I'm getting WMI Provider Error. The file exists. [0x80070050]]

[rayray]

I don't have a Template Data directory :(

[SherlockSpreadsheets]

Fixed it for me. I was able to start the service, but I had to run SQL Config Manager "As Admin". Without running as admin, I got an error: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details".

[saeid aslami]

I don't have to.

[Muhammad Abbas]

"VIA" Protocol is also not available in SQL Server 2012, Unclear Answer.

[Santiago Rebella]

Worked for an instance in SQL Server 2017, Cheers!

[Hassan Alhaj]

thank you, here is the link: docs.microsoft.com/en-us/troubleshoot/sql/admin/…