The SqlMembershipProvider requires a database schema compatible with schema version 1

by Yugolancer

Posted on Monday, October 31, 2016

If you get this error it means that the default values are missing from your database.

To resolve/fix the issue, just execute the following SQL code against your database:

INSERT INTO 
    dbo.aspnet_SchemaVersions 
VALUES
   ('common', 1, 1),
   ('health monitoring', 1, 1),
   ('membership', 1, 1),
   ('personalization', 1, 1),
   ('profile', 1, 1),
   ('role manager', 1, 1);
GO