SQL Server Express 2008 did not install successfully

Posted in Microsoft SQL Server -

While attempting to install Visual Web Developer Express 2010 SP1 on Windows 2003 Server I got the error message "SQL Server Express 2008 R2 - This product did not install successfully."

How to check the installation error

I don't actually need SQL Sever Express for the work I needed to do, so it was a little annoying that it had to be installed anyway, but there was no obvious reason it had failed, and the rest of the software wouldn't install without it.

After the second (failed) attempt to install Visual Web Developer Express, I paid a little more attention to the results screen and saw that there's a link to the error log for each failed item.

Click the error log link, and it will open in Notepad, which should shed some light on the error.

Not a strong enough password...

In my case, the installation error was because the "sa" user password I had entered earlier on in the installation process wasn't strong enough...

You would think that instead of downloading and then failing to install the software, it could have prompted me for a stronger password instead of accepting it and attempting to continue. Or just let me have my weak password :)

This may not be the reason for your error; if it is then good; if not, make sure you check the error log to see if it sheds any light on the reason for an unsuccessful installation.