The SQL Server service failed to start
The SQL Server service failed to start. For more information, see the SQL Server Books online topics, “How to: View SQL server 2005 setup log files” and “starting SQL Server Manually.” Error 29503.
Error:
The SQL Server service failed to start. For more information, see the SQL Server Books online topics, “How to: View SQL server 2005 setup log files” and “starting SQL Server Manually.” Error 29503
Error Message:
Causes:
- SQL Server needs administrative permissions to create registry entries and to create services.
- The firewall on the system might be blocking the installation.
- Application Log files in the Event viewer is full. Increase the size of the Log files.
- The SQL 2005 express edition does not support following processors AMD K6-2 processors, AMD Phenom 8400 Triple-Core processor, And Intel Xeon X5680.
- Required prerequisites for SQL Express 2005 may not be there in system.
- Antivirus on the system might be blocking the installation.
|
Solution 1:
Navigate to “C:\Documents and Settings\NetworkService\Application Data\Microsoft” and Give full control permissions to “EVERYONE” for Protect folder.
|
|
Solution 2:
Make sure that you are running the SQL Server setup as “Run as Administrator”.
|
|
Solution 3:
During SQL Server installation choose “Local System” for Service account.
|
|
Solution 4:
Need to create an “empty” registry key name as ‘Domain’ in this path
“HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameter”.
Start > run > type regedit
Navigate to this registry “HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameter”
Right Click “Parameter” > New > String Value > rename as “Domain”
|
|
Solution 5:
Don’t click on cancel, let that error message be on screen, try to rename “Microsoft” folder in the below path.
“C:\Documents and Settings\NetworkService\Application Data\Microsoft”
|
|
Solution 6:
Switch OFF the “Firewall” and “Antivirus” till installation finishes.
|
|
Solution 7:
Start > Run > eventvwr.msc > Right click Application > Properties > Change maximum log size to bigger value. And Check “Overwrite events when needed”.
|
|
Solution 8:
Don’t click on cancel, let that error message be on screen,
Grant Full rights to “NETWORK SERVICE” on the “C:\Documents and Settings\NetworkService” folder
|
|
Solution 9:
.NET Framework 2.0 SP1 and Windows Installer 3.1 must be installed in this system.
|
|
Solution 10:
Let the error message be on the screen, Transfer [SqlOS.dll and SqlServr.exe of SqlFix] to SQL installation path [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn] and click OK.
Download: SqlFix
|
|
Solution 11:
The SQL 2005 family does not support following processors AMD K6-2 processors, AMD Phenom 8400 Triple-Core processor, And Intel Xeon X5680.
|
