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.
由于原先是好的,后来出现这个错误,所以系统提示的 schema (数据库结构)错误是不准确的,甚至是误导读者,根本原因是运行脚本清除了aspnet_SchemaVersions系统初始化的数据
因此,解决方法是在aspnet_SchemaVersions里输入如下数据:
Feature CompatibleSchemaVersion IsCurrentVersion
common 1 1
health monitoring 1 1
membership 1 1
personalization 1 1
profile 1 1
role manager 1 1
顺便说一下,这个没有什么特别的,你可以运行admin tool查看系统生成的数据内容
一个朋友说他建立好asp.net需要的membership-role关系后一直正常,后来运行了脚本,再运行时出现类似如下的错误