Asked By
Vic Toledo
0 points
N/A
Posted on - 08/31/2016
If u see the message, The SQL Server 2005 service failed to start, while installing. How To Successfully Install SQL Server 2005 In Windows?
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.
