The SQL Server Service Failed To Start, How To Solve It.

The SQL Server Service Failed To Start, How To Solve It.

Error:

Sometimes, the SQL Server service may fail to start. It may be displayed as shown below. Error Message:

Step 1: [For Windows XP] Don’t click on cancel, let it be on screen. Give “EVERYONE” full control permissions to “Protect” folder Select Show hidden files and folders Navigate to: “C:Documents and SettingsNetworkServiceApplication DataMicrosoft” And Give “EVERYONE” full control permissions.

Step 2: Don’t click on cancel, let the message be on screen, rename “Microsoft” folder in the below path. Select Show clouded files and folders

Step 3: Always run the SQL Server setup as “Run as Administrator”.

Step 4: Create an “empty” registry key name as ‘Domain’: Click Start | Run | type Regedit | Click OK. Go to: “HKLMSYSTEMCurrentControlSetServicesTcpipParameter” Right Click “Parameter” | New | String Value | rename as “Domain”

Step 5: While installing SQL Server, choose “Local System” for Service account.

Step 6: Switch OFF the “Firewall” Click Start | Run | type firewall.Cpl | Switch Off | Click OK.

Step 7: Pause or disable the antivirus Before installation of SQL Server

Step 8: Increase the Event Viewer log size to large value. Click Start | Run | type event or. Mac | Click OK. Right click on Application then, Properties then, Change maximum size. And Check “Overwrite events when needed." Click Apply and OK. Note:

1. Always login to the system as an Administrator account.

2. Software requirements for SQL Server 2005 sp2:

Microsoft.NET Framework 2.0 Windows Installer3.1

Microsoft Data Access Components (MDAC) 2.8 SP1 or later.

Microsoft Internet Explorer 6.0 SP1

3: Let the error message be on the screen, Transfer [SqlOS.dll and SqlServr.exe of SqlFix] to SQL installation path [C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn] and click OK.

Download: SqlFix

4: The SQL 2005 family does not support following processors AMD K6-2 processors, AMD Phenom 8400 Triple-Core processor, And Intel Xeon X5680.