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.
There is only one instance SQLEXPRESS. Image attached.
* There was an error trying to connect to the Database Server:
System.InvalidOperationException: Instance failure. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps) at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.createRealCon() at OpenAccessRuntime.Relational.conn.RelationalConnectionPool.init() at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.connect() at OpenAccessRuntime.Relational.RelationalStorageManagerFactory..ctor(StorageManagerFactoryBuilder b) at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
A) Delete C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS.
B) Modify the SQL Server (SQLExpress) service to use your local or system account and restart the service.
Go into Administrative Tools-:>Services. There should be a SQLEXPRESS service. Right click on it then select Properties->Log-On.