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

Viewed 339985

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

19 Answers

It was very tedious when I get same problem. When I got this problem, I uninstall my SQL Server 2008 but after installing the SQL Server 2008 again,I got the same problem. I was so tensed plus, I had not gotten any help from any site.

To over come this problem. Simply You Need to go on SQL Server Configuration Manager and then click On Protocols on left panel. If you running Network service just disable 'VIA' Protocol. And after that try to start your SQL service it will run successfully.

In my case, the issue was that I was running two other SQL Server instances which were (or at least one of them was) causing a conflict.

The solution was simply to stop the other SQL Server instance and its accompanying SQL Server Agent.

stop sql server service

While I'm at it, I'll also recommend making sure Named Pipes is enabled in your server's protocol settings

SQL Server Protocols Named Pipes 1

SQL Server Protocols Named Pipes 2

I had a similar issue. The next solution is in *case to can't launch the server Locally * and you will see the same error msg.(Image 1)

enter image description here Imagen 1

enter image description here Imagen 2

To solve that and have the server working you must have the next steps.

  1. Go to SQL Server Services
  2. Right click to open properties
  3. Go to LogOn tab (By default you will see something like Image 3)
  4. Select the radio button Built-in account (Image 4)
  5. Click on Ok
  6. Go back to SQL Server Services and launch again the server (Image 5) After that you must be able to see run it.

Image 3 Image 3

enter image description here Image 4

enter image description here Image 5

I hope that works for you or others with similar issues. Follow me for more tips.

I found from event logs that My SQL server evaluation has expired. I needed to upgrade or needed to use community edition.

For me a simple windows update fixed it, I wish I tried it before.

I have SQL 2017 installed and this issue happens when the free trial / evaluation period ends, the solution to the problem is the following:

1 - Go to the windows start button, find the Microsoft SQL Server 20XX folder

2- Then, SQL Server 20XX Installation Center

3- On the left, select the option "Maintenance"

4- Then click on “Edition upgrade”

5- Then in the combox select "developer" option, and then click on “next” button

6- Click on the option "I accept the license terms" and then next

7- Finally, click on "Next" and click on "Upgrade", and wait approximately 15 minutes.

8- After this, restart the SQL Server service in "Services.msc" and open SQL again, it should work. For more information: watch this video: https://www.youtube.com/watch?v=EVG35ahhjec

If you are still scrolling through the answers, here is one more step you might have missed.

Open SQL server configuration manager with admin access.

Apply the changes first(to local System) and then try to run.

enter image description here

If you are configuring your SQL Server connection using Computer Management under Administrative Tools or SQL Server Configuration Manager in Enterprise or Corporate environment, make sure you open your Computer Management or SQL Server Configuration Manager as an Administrator or you have

Administrative Privileges

All answers above didn't work for me, but when I run it as Administrative mode, I can now start my SQL Server Agent or SQL Server service.

For me happened similar issue when I did uninstall Microsoft Visual C++ 2015-2020 Redistributable and installed the Microsoft Visual C++ 2017 version

Fixed this issue when re-installed Microsoft Visual C++ 2015-2020 Redistrubutable versions. then services started automatically.

Try changing login from different account:

  1. Open SQL Server Configuration Manager as Admin.
  2. Right click SQL sever and SQL Server Integration Services.
  3. Go to Properties and choose Log on.
  4. Choose Built in account.
  5. Select local service.
  6. Apply and Ok.
  7. Start service again.
Related