asp.net 2.0自带了三个provider
1.AspNetSqlMembershipProvider
2.AspNetSqlProfileProvider
3.AspNetSqlRoleProvider
在使用用户管理&登陆控件时需要使用此Provider:
下面是Machine.config配置中的信息:
<membership>
<providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</profile>
<roleManager>
<providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
如果需要自己提供Provider, 可以在web.config添加类似的配置信息:
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
<providers>
<add connectionStringName="SqlServices" enablePasswordRetrieval="false"
enablePasswordReset="true" requiresQuestionAndAnswer="true"
passwordFormat="Hashed" applicationName="/" name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
<roleManager enabled="true" cacheRolesInCookie="true" cookieName=".ASPROLES"
cookieRequireSSL="true" defaultProvider="SqlProvider">
<providers>
<add connectionStringName="SqlServices" applicationName="/" name="SqlProvider"
type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>
然后运行asp.net configuration 选择就可以。
下一步就是数据库生成问题,可以使用aspnet_regsql 生成相关数据库表&存储过程到指定的数据库
C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/aspnet_regsql -S local -d Database -E -A all
1.AspNetSqlMembershipProvider
2.AspNetSqlProfileProvider
3.AspNetSqlRoleProvider
在使用用户管理&登陆控件时需要使用此Provider:
下面是Machine.config配置中的信息:
<membership>
<providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" />
</providers>
</membership>
<profile>
<providers>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</profile>
<roleManager>
<providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
如果需要自己提供Provider, 可以在web.config添加类似的配置信息:
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">
<providers>
<add connectionStringName="SqlServices" enablePasswordRetrieval="false"
enablePasswordReset="true" requiresQuestionAndAnswer="true"
passwordFormat="Hashed" applicationName="/" name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
<roleManager enabled="true" cacheRolesInCookie="true" cookieName=".ASPROLES"
cookieRequireSSL="true" defaultProvider="SqlProvider">
<providers>
<add connectionStringName="SqlServices" applicationName="/" name="SqlProvider"
type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>
然后运行asp.net configuration 选择就可以。
下一步就是数据库生成问题,可以使用aspnet_regsql 生成相关数据库表&存储过程到指定的数据库
C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/aspnet_regsql -S local -d Database -E -A all