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?

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?

Cannot Install SQL Server 2005 along side SQL Server Express

Hi,

I have SQL Express edition installed. Now when i am trying to install SQL server 2005 June CTP i get an error saying "SQL Server setup cannot run. Another instance SQL Server Setup is already running. The running instance must complete before you can run the SQL Server setup again". I have restarted my machine twce but still i get this error message.

Any ideas?

Regards

Deepak

I'm having the same problem. I installed the Visual Web Developer 2005 Express Edition a couple of weeks ago, then attempted to install SQL Server 2005. I had to completely uninstall VWD to get the SQL Server 2005 install to work. After that, I tried to re-install VWD with SQL Server Express and it wouldn't work. I'm running all of this on XP Pro with .NET Framework 2.0 (not the BETA). One thing I haven't checked is if VWD can detect the SQL Server 2005 installation somehow, without having to install SQL Server Express altogether. I'll let you know what I find out.

-- TreeSapp

|||Try checking out Task Manager. See if there is a "setup.exe" running, but not doing anything. If you aren't installing, try killing it off, then running again. Not sure if this will help or not, but it's the only suggestion that I have.|||

No, I rebooted between installs to make sure that nothing else was running, checking Task Manager each time. I even made sure that the "PendingFileRenameOperations" registry entry was not set before and after each install. I also verified that each install completed successfully by simply executing the apps. I just can't seem to get both installed at the same time.

- TreeSapp

|||

Okay, go ahead, clean up the machine again (uninstall SQL and delete the %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\Log\Files directory), then install VWD Express. Then install SQL (I'm assuming you'll get your error).

Can you then look at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt. It should say what the problem is. If so, great, if not, can you copy/paste the error segment +/- 10 lines?

Thanks,

-Jeffrey