各种提供程序的参考

WebParts的个性化设置的提供程序

<webParts>
<personalization defaultProvider="AspNetSqlProvider">
<providers>
<add connectionStringName="YOUR_CONNSTRING" applicationName="/Web" name="AspNetSqlProvider" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider"/>
</providers>
</personalization>
</webParts>

用户提供程序

<connectionStrings>
<remove name="LocalSqlServer"/>  或者 <clear/> 未知 要测试
<add name="LocalSqlServer" providerName="System.Data.SqlClient" connectionString="server=(local);database=wddhy;uid=sa;pwd=" />
<add name="MyConnection" providerName="System.Data.SqlClient" connectionString="server=(local);database=wddhy;uid=sa;pwd=" />
</connectionStrings>
<system.web>
<membership defaultProvider="MyAspNetSqlProvider" userIsOnlineTimeWindow="20">
 <providers>
  <remove name="AspNetSqlProvider" />
  <add name="MyAspNetSqlProvider"
   type="System.Web.Security.SqlMembershipProvider"
   connectionStringName="LocalSqlServer"
   enablePasswordRetrieval="false"
   enablePasswordReset="true"
   requiresQuestionAndAnswer="false"
   applicationName="/"
   requiresUniqueEmail="false"
   passwordFormat="Hashed"
   minRequiredPasswordLength="6"
   minRequiredNonalphanumericCharacters="0"
   passwordStrengthRegularExpression="" />
 </providers>
</membership>

修改 用户提供程序 于 程序数据库 在一起

<connectionStrings>
<remove name="LocalSqlServer"/>  或者 <clear/> 未知 要测试
<add name="MyConnection" providerName="System.Data.SqlClient" connectionString="server=(local);database=wddhy;uid=sa;pwd=" />
</connectionStrings>
<system.web>
<membership defaultProvider="MyAspNetSqlProvider" userIsOnlineTimeWindow="20">
 <providers>
  <remove name="AspNetSqlProvider" />
  <add name="MyAspNetSqlProvider"
   type="System.Web.Security.SqlMembershipProvider"
   connectionStringName="MyConnection"
   enablePasswordRetrieval="false"
   enablePasswordReset="true"
   requiresQuestionAndAnswer="false"
   applicationName="/"
   requiresUniqueEmail="false"
   passwordFormat="Hashed"
   minRequiredPasswordLength="6"   密码长度
   minRequiredNonalphanumericCharacters="0"   特殊字符个数
   passwordStrengthRegularExpression="" />
 </providers>
</membership>

但是 上面有个问题 就是角色 提供程序 没有写 所以 它还会找默认的LocalSqlServer

Profile 提供程序的配置

<configuration>
<connectionStrings>
<add
name="myConnectionString"
connectionString=
"Server=MyServer;Trusted_Connection=true;database=MyDatabase" />
</connectionStrings>
<system.web>
<anonymousIdentification enabled="true" />
<profile defaultProvider="MyProfileProvider">
<providers>
<add
name="MyProfileProvider"
type="System.Web.Profile.SqlProfileProvider"
connectionStringName="myConnectionString" />
</providers>
<properties>
<add
name="FirstName"
allowAnonymous="true" />
<add
name="LastName"
allowAnonymous="true" />
</properties>
</profile>
</system.web>
</configuration>