Eli Weinstock-Herman

'LocalSqlServer' Error Deploying WebSecurity in WebMatrix/Web Pages

Original post posted on August 09, 2011 at LessThanDot.com

Several weeks ago I was working on a sample site in Web Matrix and ran into a brick wall when I attempted to implement WebSecurity against my website. It seemed no matter what I tried I was getting errors about my database, errors about a database I didn't know about, errors trying to deploy the config file at all. After hours of debugging and random attempts at web.config hackery, I finally tried the basic starter sites and found out that those, too, suffered from problems when you attempt to deploy them.

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.

Today I managed to solve it based on an archived forum post I found through google.

The solution is to add the following section to your web.config:

Code: xml
<!-- Added in an attempt to make simple security work -->
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="Data Source=.\App_Data\MyJunk.sdf" providerName="System.Data.SqlServerCe.4.0" />
    <add key="enableSimpleMembership" value="true" />

Basically what is happening is that my web host has a machine.config with a SQL Connection string called "LocalSqlServer" (it's created by default by the .Net framework). For some reason when we use anything Membership related, it attempts to access the configured connection string for Membership, even though WebSecurity is provided it's own connection string on initialization.

So the solution is to remove the settings that has been applied to our site from the host's machine.config and apply a new one. From what I can tell, it doesn't seem to matter if the new connection string is accurate, only that it exists.

Yep, this means I don't actually have a SQLCE database named, MyJunk. I can tell you're disappointed. Also I don't know if ./ would work in this path, so please don't use this as a how-to guide on how to create a working SQLCE connection string.

Comments are available on the original post at lessthandot.com