Cannot install SQL Server Express

I'm attempting an new installation on an Athlon 64 3300 system running XP Pro using the default install options. Get the message "SQL Server service failed to start..." and the installer starts Rolling Back the installation leaving me with a bunch of log files that mean nothing to me.

I'm not savvy enough to solve this one. Can anyone help?

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Oct 19 20:09:10 2006
Machine : SR1365CL
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLSupport_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLNCLI_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SqlWriter_1.log
--
Machine : SR1365CL
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_MSXML6_1.log
--
Machine : SR1365CL
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 : SR1365CL
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_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
--

What does the event log tell you ? There should be an entry about the starting service. There might be permission or service account problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

My ERRORLOG shows this error:

2006-10-19 20:14:59.51 spid5s Starting up database 'mssqlsystemresource'.
2006-10-19 20:14:59.51 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2006-10-19 20:14:59.65 spid5s Error: 15209, Severity: 16, State: 1.
2006-10-19 20:14:59.65 spid5s An error occurred during encryption.

This KB article gave me the information necessary to complete the install although the .\Protect folder did not yet exist.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114

Problem solved. Thanks for the nudge in the right direction, Jens.

John

|||

I also found this thread VERY helpful, and I would just like to add two comments:

1) This applies to intel 32bit processors as well.

2) When you attempt to check the security tab for folder C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect, you may notice that there is no security tab. In that case you are using "simple file sharing", which will need to be disabled. Disable by: control panel-> folder options->view and uncheck "use simple file sharing (Recommended)" at bottom. Then, follow KB920114.

Jim

|||I am getting exactly the same error as above. I followed the directions in KB920114, but the Network Service already had full authority. So there is nothing for me to change. Needless to say, it doesn't work. Any other ideas?