ASP.NET Membership Error

Question

I'm using ASP.NET MVC. I inserted ASP.NET membership tables into my database and i'm getting the error written below. Solution maybe? Thanks.

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.

Answer 1

1. Make sure the "aspnet_SchemaVersions" table exists in your database
2. Make sure it contains an entry for each "feature" you are using. The aspnet scripts should do this for you.
3. Check your security (connection string) to see if you have the right to select from that table, exec the procs, etc. from the web app.

Answer 2

Did you run the aspnet_regsql.exe file?

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

I've done this countless times and never got that error. Try doing that.

EDIT:

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

Also take a look at this