The request failed or the service did not respond in a timely fashion?
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.
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
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