Error:

The service did not respond to the start or control request in a timely fashion, you need administrator priviliges to be able to start\stop this service.

Error Message:

Causes:

1. Give correct system name and instance name.
2. VIA protocol might be enabled and it may be using port 1433.
3. SQL Browser service might be stopped/disabled.
4. SQL Server might be corrupted need to reinstall and required to attach the data files.

Workaround 1:

Disable “VIA” protocol:

Open SQL Server Configuration Manager as Run as Administrator

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager | SQL Server Network configuration | Protocols for RELYONDB

The status of “VIA” protocol should be disabled |

Right click “VIA” | Properties | Default Port should be empty.

Workaround 2:

Open SQL Server Configuration Manager as Run as Administrator

Restart both SQL Server RELYONDB Service & SQL Server Browser services.

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager | SQL Server 2005 Services

Right click SQL Server RELYONDB and select Restart

Right click SQL Server Browser and select Restart

Workaround 3:

Are you logged into the machine with an account that is in the Administrators group

Please log on to Windows using administrator account. Also, restart Windows Management Instrumentation (WMI) service from services, and then try to restart SQL Server service again.

Workaround 4:

Grant FULL permissions to “SQLServer2005MSSQLUser$machine_name$instance_name” user and “SQLServer2005SQLBrowserUser$machine_name” user on SQL server  DATA folder.

Workaround 5:

Include the logged in User account to Debug programs:

Open Group Policy…
Start | Run | Type: gpedit.msc | OK |
Navigate to
Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug programs

The account through which we are trying to run the setup should be here ( besides the local admin on that machine). Restart the server ( this is mandatory)not work) and ran the setup and it was successful this time.

SQL Server 2008 setup needs this privilege to start up the SQL Server process and listen to an event that signals back to setup that SQL Server successfully started.

Install SQL Server freshly.