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.

GalacticCowboy · Answer 1 · 2009-05-27T23:06:49.537

5

Make sure the "aspnet_SchemaVersions" table exists in your database
Make sure it contains an entry for each "feature" you are using. The aspnet scripts should do this for you.
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.

edited May 27 '09 at 23:06

answered May 27 '09 at 21:28

GalacticCowboy

11,663
2
41
66

Carlo · Accepted Answer · 2009-05-27T21:07:10.853

3

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

edited May 27 '09 at 21:07

answered May 27 '09 at 17:28

Carlo

25,602
32
128
176

What do you mean, did that fix it? – Carlo May 27 '09 at 18:54
Also, make sure you restart your website for changes to take effect. – danfolkes Jul 02 '12 at 18:55

score 3 · Answer 3 · answered May 28 '09 at 20:51

Thanks for the replies. These articles are very helpful. I figured out the problem though and it was a typical bonehead mistake. I used a script to recreate all the tables for Membership. I didn't copy any data into those tables. There is a table called aspnet_schemaversions. It requires some values to be able to validate the versions (duh). When I added these values into the table, it started working.

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

This is absolutely the answer – Ali.Rashidi Dec 19 '16 at 07:01 — Ali.Rashidi, Dec 19 '16 at 07:01

score 0 · Answer 4 · answered Mar 02 '17 at 04:30

Old post, but I had a different solution:

In my connection strings in the web.config, I had Persist Security Info=True; included. Removing this solved my schema error,

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

ASP.NET Membership Error

4 Answers4

Linked