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
Error Number : 29503 The SQL Server service failed to start.
tnyjr123456
Correction on the website...
http://www.kingenterprises.dynu.com/SQLSetup0003_KINGSERVER550_SQL.log.txt
It seems IIS will not serve a "log" file extension.
Betuca
Did you look in this log file
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_KINGSERVER550_SQL.log
Sam George - MSFT
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.
Kamen Yotov
Hi,
It says that the AMD K6-2 is not supported. But the processor on my server is AMD Opteron (TM). And as per this article, Microsoft has introduced support for this processor:
http://www.microsoft.com/presspass/press/2004/jul04/07-26SupportAMDOpteronPR.mspx
The error that I still keep getting is:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
------------------------------
BUTTONS:
OK
------------------------------
The above link though does not provide the details. I am not sure what I could do !
Thanks a lot..
Mannu.
ondulacao
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.
marit
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