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.
Error Message:
Causes:
- Give correct system name and instance name.
- VIA protocol might be enabled and it may be using port 1433.
- SQL Browser service might be stopped/disabled.
- SQL Server (RELYONDB) service might be stopped/disabled.
- SQL Server master data might be corrupted.
Workaround 1:
Open SQL Server Configuration Manager
Start | Programs |Microsoft SQL Server 2005|
Navigate to: SQL Server Configuration Manager\SQL Server Network configuration\Protocols for RELYONDB
Right click “VIA” protocol and click disable. [The status of “VIA” protocol should be disabled]
Right click “VIA” | Properties | Default Port should be empty.
Workaround 2:
Restart both SQL Server RELYONDB Service & SQL Server Browser services.
Workaround 3
Remove Microsoft SQL Server 2005 completely from Control panel
Control Panel | Add or Remove Programs | Microsoft SQL Server 2005
In the first dialog, make sure to select the “RELYONDB: Database Engine” radio button.
If RELYONDB is the only instance, then select all check boxes & Click Next and Finish to proceed with the uninstall.
If there is no other SQL instance, I would go on to clean out all SQL components with the following steps.
Uninstall Microsoft SQL Server Native client
Uninstall Microsoft SQL Server Setup support files
Uninstall Microsoft SQL Server VSS writer
Delete the following keys in registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
and delete all the keys referencing SQL Server.
Rename all the SQL Server folders in the computer.
Install SQL Server 2005 RELYONDB
Really help me lot , thx for your post
Thanks a lot,
Thks so much.
May i can try in XP OS.
But i have an other way that you can try.
Open Services.msc on Window + R type services.msv.
Looking for SQL server, i think the status it is stoped now, so right click choose Properties, In startup type choose automatic then click Apply, In service status: click start. then OK.
Now, you can back SQL Server Configuration Manager and try start again your SQL server.
Hope is working.
I’m Vietnamese. 🙂 My english is so bad. So you can contact me via Gmail: dinhtona@gmail.com
Thks for reads.