I had the basics of a site going in v8 using SqlCE. I installed the uCommerce package from the admin pages and from that point I could not get the site to start again, as it complained about the 'flush interval' property of the connection string. Removing that property didn't help, as I get instead a 'cannot locate server' SQL connection error.

In frustration I ported the CE database to SQL Express, updated the connection strings and commented out the DbProviderFactories in web.config.

Curiously when starting the app it seems to boot OK (based on the logs), but then goes into a bit of a loop about Updating Ucommerce is needed, but no logged in user could be found. Please access a page with an authenticated user. and Connection string was found. Server=.\\SQLExpress;Database=Umbraco119;Trusted_Connection=Yes;

After a half-dozen of these message pairs I get the Umbraco installer page, and if I click "Continue" my connection string is immediately reset to the SQL CE version, a new database is provisioned, and the whole thing goes bang with errors about The specified table does not exist.

Does anyone know why Umbraco would reset the connection string like this? How can I stop that??