SF 4 installed fine on SQL Server 2005. For compatibility reasons I uninstalled SQL Server 2005 and installed SQL Server Express 2008 R2. I uninstalled SF, deleted SF folder and reinstalled SF to reset SF system. Problem is the SF4 start-up page cannot connect to SQL Express 2008 R2 under SQL Express 2008 setting. I have tried various things; making sure tcp/ip protocol was enabled, SQL Browser service running, firewall access for sqlserver.exe etc but no luck. The only way I can make SF4 to work is to tell SF start-up page to install as SQL Server (even though backend db is still SQL Express 2008) and then it installs fine.
What could be the likely problem here with access to sql server express 2008? I have a feeling it will also create problem in running the starter kits apps. A tried a couple of them and they had db access issues as well.