Error Number : 29503 The SQL Server service failed to start.

Is there a trick to getting this installed correctly? Everything works great until it gets up to starting the service. Here is the complete section of my setup log file.

SQL 2005 Standard.

Machine : KINGSERVER550
Product : SQL Server Database Services
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."
--
Machine : KINGSERVER550
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_KINGSERVER550_SQL.log
Last Action : InstallFinalize
Error String : 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."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503

I searched a previous thread dealing with this error, but seems like nobody has found a solution.

--Tony

Did you look in this log file

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_KINGSERVER550_SQL.log

|||

Well, I took a look at the log file you specified and there is a small section that contains the same information and informs me to look in the SQL Server Books Online.

Here is an excerpt from the log file. It is also on my server accessible through the following link.

http://www.kingenterprises.dynu.com/SQLSetup0003_KINGSERVER550_SQL.log

- Context --

Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL

Error Code: 1067
MSI (s) (5C!6C) [14:50:06:117]: Product: Microsoft SQL Server 2005 -- Error 29503. 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."
The error is (1067) The process terminated unexpectedly..Error 29503. 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."

The error is (1067) The process terminated unexpectedly..<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Wed Mar 29 14:50:06 2006
Service MSSQL$KINGSQL with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Wed Mar 29 14:50:06 2006 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls::Service::Start
Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL

Error Code: 1067 MSI (s) (5C!6C) [14:50:12:937]: Product: Microsoft SQL Server 2005 -- Error 29503. 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."
The error is (1067) The process terminated unexpectedly..

Error 29503. 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."
The error is (1067) The process terminated unexpectedly.

|||

Correction on the website...

http://www.kingenterprises.dynu.com/SQLSetup0003_KINGSERVER550_SQL.log.txt

It seems IIS will not serve a "log" file extension.

|||

You might check the SQL engine log file, located somewhere like this: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. If the engine tried to start and failed, the reason will be in there.

|||

FOUND MY PROBLEM!!

FOUND MY PROBLEM!!

The error relates to the type of processor used on the machine that is loading SQL 2005 (Std, Devoper, Enterprise, etc...)

Take a look at this post on the following website.

http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=167

Apparently the SQL 2005 family does not support AMD K6-2 processors. Anyone else have this problem?

In specific, my processor is: AMD K6-2 550 MHz

x86 Family 5 Model 8 Stepping 12, AuthenticAMD

Problem solved!! Upgrade my damn 'puter.

Thanks anyway everyone!

Tony