ASP.NET ERROR: The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'

---

  
Free Lessons for Chruch Pianists:
Free lessons, tips and downloads for church pianists

DVD Courses (Reharmonization, Play by Ear!, Arranging, Accompanying, Theory for Church Pianists, etc.):
Over 30 hours of DVD instruction for church pianists

 

---

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.

Solution:

1. Open Microsoft SQL Server Management Studio

2. ...Connect...

3. Click 'Databases' node

4. Right-click node of the database you are using

5. Select 'New Query' option

6. Copy and paste the query below:

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

7. Click 'Execute' (or right-click on the page -> 'Execute')

[Note: this answer is from http://stackoverflow.com/questions/3292794/the-system-web-security-sqlmembershipprovider-requires-a-database-schema-compa]