How to fix the error: SystemWebSecuritySqlMembershipProvider requires a database schema compatible with schema version 107/01/2010
Recently while upgrading an ASP.NET 2.0 project to ASP.NET 4.0 I ran into a database issue. After creating a new Sql Server 2008 database project and setting up my isolated work environment, I received the following error:
The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.
According to several sources on the Net you need to add an applicationName attribute to your provider definitions in web.config. So any Membership Framework provider definition that has for instance "connectionStringName" will also have to have this attribute: applicationName="NoSingleSlash". The caveat is that you cannot use applicationName="/". You have to provide a multiple word name.