I'm new with development and just wanted to get the Personal Website Sample to work. So far, I'm have am having a terrible time installing SQL Express Edition. I'm not exactly sure what to do next. I have installed, manually uninstalled, and reinstalled many times. Sometimes I get error 29503 & 1067. Other times when I reinstall I get 29503 & -2146885628 . Here's the info I got so far for my 29503&1067 since that error occurs 95% of time. I believe I got the -2146885628 error when I changed a setting from network to local services.
I feel so confused right now. Any help would be appreciative.
From the Summary Log:
Code Snippet
Machine : DELL1Product : 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 : DELL1
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0018_DELL1_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
--
From there, I searched the error logs to find this in the SQL.log
Code Snippet
- Context --
Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 1067
MSI (s) (84!D4) [01:48:10:750]: 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.
.
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue Aug 28 01:48:10 2007
Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qJapanese_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:48:10 2007
Service failed unexpectedly (1067)
Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly.
Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
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$SQLEXPRESS
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$SQLEXPRESS
Error Code: 1067
MSI (s) (84!D4) [01:48:13:968]: 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.
.
MSI (s) (84:10) [01:48:14:109]: User policy value 'DisableRollback' is 0
MSI (s) (84:10) [01:48:14:109]: Machine policy value 'DisableRollback' is 0
Action ended 1:48:14: InstallFinalize. Return value 3.
MSI (s) (84:10) [01:48:14:171]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=924585293,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (84:10) [01:48:14:171]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server 2005)
MSI (s) (84:10) [01:48:14:171]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (84:10) [01:48:14:171]: Executing op: ProductInfo(ProductKey={B0F9497C-52B4-4686-8E73-74D866BBDF59},ProductName=Microsoft SQL Server 2005,PackageName=sqlrun_sql.msi,Language=1033,Version=151129058,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIcon.ico,PackageMediaPath=\Setup\,PackageCode={08AD0897-0300-4F7D-A3CC-A0CCEDD42E0D},,,InstanceType=1,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (84:10) [01:48:14:171]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
MSI (s) (84:10) [01:48:14:171]: Executing op: CustomActionRollback(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server81062400lpc:DELL1\SQLEXPRESS)
MSI (s) (84:B4) [01:48:14:171]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI571.tmp, Entrypoint: Rollback_sqlScript
Function=Rollback_sqlScript
Doing Action: Rollback_sqlScript
This log does get kind of big, so if you need more information, please feel free to ask
The first link is a cleaned up version of the Personal Starter Kit and the second link is where he can answer your questions. The third link is tutorials for many starter kits. Hope this helps.
http://www.jeremywadsworth.com/
http://forums.asp.net/1003.aspx
http://msdn2.microsoft.com/en-us/library/aa530759.aspx
|||Will I ever need to install SQL EE (right now I'm SQL less)? This error looks really big and I'm not sure exactly how to solve it.|||
EDIT
I don't see how you plan to run an application that needs SQL Server database without running Express. Express Advanced that is almost like the full edition is free. If you plan to develop you can download the Advanced below.
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
|||Still waiting around for an answer to my install errors. I did install mySQL in about 15mins vs 3 full days and counting for SQL Server EE. It's pretty nice...but besides that, still wondering if anyone knows about these SQL EE Errors?|||
You cannot install MySQL and expect to run software created to use SQL Server Here is the thing I have installed the kit without problem a whileback and you are having problem so read those tutorials in my recent post the two for this kit and post in the forum I gave to you.
|||I am very very confused now.I can't install SQL Server Express Edition because I get errors 29503 & -2146885628 during the install process. Thus, SQL Server Express is not installed in my computer.
The links you gave me are troubleshooting tips for the Personal WebKit. Since you gave it too me, I thought I could run it without SQL Server Express Edition but your reply to that makes it sound like I need SQL Server Express Edition which I cannot install due to the errors above. I already install, manually uninstall, etc etc etc. As far as I can tell, during my install process, SQL Server Express Edition just installs maybe 80% of what it should be installing because my summary log says this:
I am assumming because my summary log says "Failed" in the install section, that SQL Server failed to install. I may be wrong and this may be a bug in the summary log.
I am very very confused now. Do I or do I not need to install SQL Server Express Edition first?
|||SQL Server 2005 is the easiest SQL Server to install I have installed 7.0, 2000 and now 2005 on all exist operating systems except Vista, that means server included. Now if you are running XP it comes with System Restore roll your Operating System back by one month if you have restore point that far back. You cannot install this starter kit without SQL Server because I have not seen MySQL versions of it. The link I gave you is where errors for this kit are resolved and you are right your current problem is SQL Server installation so now go roll back the Operating System and try the install again. Now go do some work and post again.|||
I did a search and found a number of possible causes of this error, but the log segment you provided does not provide enough information to really tell what the issue is. For starters, check out the KB article at http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114 and see if this applies to your situation.
If that doesn't work, search the log for "ue 3" to find any lines that contain 'Return Value 3' indicating a failure. The several lines above the return value should give you a more specific message about what actually failed to cause the error you're seeing. If that information doesn't point you in an obvious direction, post that snippet to the forum and we can take a look at it.
Mike
sql