Error:

Windows could not start SQL Server (RELYONDB) on local computer. For more information, review the system log.

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 service might be stopped or disabled.
5. SQL Server might be corrupted need to reinstall and attach the data files.

Workaround 1:

Enable Using both TCP/IP and Named Pipes:

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager| SQL Server Network configuration| Right Click “Named Pipes” & Click Enable > Right Click “TCP\IP” & Click Enable

Restart SQL Server RELYONDB and SQL Server Browser service.

Workaround 2:

Enable Using both TCP/IP and Named Pipes:

All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Surface Area Configuration | Configuration for Services and Connections | Remote Connections, choose Local and Remote Connections |Enable Using both TCP/IP and Named Pipes.

Restart SQL Server RELYONDB & SQL Server Browser service.

Workaround 3:

Click Start | Run | type firewall.cpl | Switch Off | Click OK.

or

Create an exception in windows firewall.

Add TCP port or sqlservr.exe to Firewall exception list, either add “..\Binn\sqlsevr.exe” or add port.

Add Sql Browser service to Firewall exception list, you can either add program ” C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe” or add UDP port 1434.