The request failed or the service did not respond in a timely fashion?
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
Had the same problem, I fixed it.
- Open SQL Server Configuration manager
- Click on the SQL Server Services (on the left)
- Double-click on the SQL Server Instance that I wanted to start
- Select the
Built-in account
radio button in theLog On
tab and choose Local system from the dropdown menu - Click apply at the bottom, then right click the instance and select
Start
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
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.
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.
If you recently changed the password associated with the service account:
- Start SQL Server Configuration Manager.
- Select SQL Server Services in the left pane.
- Right click the service you are trying to start in the right pane and click Properties.
- Enter the new Password and Confirm password.