Wednesday, February 15, 2012

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]