Have tried the installation of Sharepoint foundation 2010 and faced the above error.
Environment: Windows Server 2008 R2 Enterprise edition + SP1 , and SQL Server 2008 R2 + Sp1
Sharepoint foundation server 2010 installation is always pointing to the SQL Server Express
Log file can be find at the following path
ERR:0:Fail to install or config SQL Express.
To get rid of this error, uninstall the sharepoint which is failed due to the above error.
Start again fresh installation by selecting the following (Server Farm) option…
Follow the wizard steps and sharepoint installation will successfully complete.