Geek Answers Handbook

ASP.NET Membership Error

I am using ASP.NET MVC. I inserted the ASP.NET membership tables into my database and I get the error written below. Maybe a solution? Thanks.

"System.Web.Security.SqlMembershipProvider" requires a database schema compatible with version of schema "1". However, the existing database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the infrastructure installation directory) or upgrade the provider to a newer version.

+4
source share
4 answers

Have you run the aspnet_regsql.exe file?

C: \ WINDOWS \ Microsoft.NET \ Framework \ v2.0.50727 \ aspnet_regsql.exe

I have done this countless times and never received this error. Try to do it.

EDIT:

alt text http://img529.imageshack.us/img529/9678/schema.png

Also take a look at this

+3
source
  • Verify that the aspnet_SchemaVersions table exists in your database.
  • Make sure it contains an entry for each "function" that you use. Aspnet scripts should do this for you.
  • Check your security (connection string) to find out if you have the right to choose from this table, execute proc, etc. from a web application.
+5
source

Thanks for answers. These articles are very helpful. I figured out the problem, even though it was a typical bone error. I used a script to recreate all the tables for membership. I did not copy the data to these tables. There is an aspnet_schemaversions table. This requires some values ​​to be able to check for versions (duh). When I added these values ​​to the table, it started working.

general 1 1 health monitoring 1 1 membership 1 1 personalization 1 1 profile 1 1 role manager 1 1

+3
source

Old post, but I had a different solution:

In my link lines in web.config I have included Persist Security Info=True; . Removing this problem solved my schema error,

"System.Web.Security.SqlMembershipProvider" requires a schema database compatible with the schema version '1'.

0
source

More articles:


All Articles