Wednesday, January 03, 2007

Error Installing SQL Server 2005 Express

After trying to install SQL Server 2005 Express Edition on my machine, I got through almost the entire install before it failed with an error message:

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."

Argh!

If you get this, you should be able to do a quick fix and then click on Retry. Unlike me, who clicked on Cancel and then had to go through almost the entire setup process again!

Anyway, if you look in your log file, you should see something like the following:

Error Code: 1067
MSI (s) (4C!44) [09:42:09:089]: Product: Microsoft SQL Server 2005 Express Edition -- 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.

Microsoft has a KB article about a fix for a error on install, but when I read the expected symptoms, it didn't quite look like it was a match. However, following the workaround in this KB article will fix your problem. Well, it fixed mine anyway.

The article can be found here:
http://support.microsoft.com/default.aspx/kb/920114

Note: the article talks about a Protect folder that requires changes to its permissions, but this folder did not exist on my machine. Creating the folder first and then applying the permissions worked like a treat.

6 comments:

Unknown said...

Thanks for the info! This type of posts are what makes Internet so valuable :)

Dan said...

I tried this solution.. As you are, i dont have the 'Protect' folder..so i tried to create one. When i check the properties of the folder, i can't find any 'Security' tab there...

Mind to clear me up here? Thanks a lot..

Adrian Brown said...

Hi Dan,

What OS are you running? I am running XP Pro - it may be different in Vista.

It could also be that your system admin guys have locked down that tab, depending on your own user permissions (if you are part of a network).

Hatake_Kakashi said...

IT villager don't know English. that is very terrible. <- my condition

Xarlot Gray said...

Thank you.

This saved my life.

Ramsiss Isiss said...

Hi Dan,

I tried the formula you prescribed,
but to no avail.

I am running a Win7 OS,i located the "Protect" folder at C:\Users\****\AppData\Roaming\Microsoft

Configured as you suggested, but yet still the same error pops up.
Every other component seems to install well, except starting the server part.

Any help regarding how i could proceed further would be most helpful.