在创建用户角色时，app_data文件下自动生成ASPNETDB.MDF数据库
作者：大鹏 发布于：2008-2-2 9:33 Saturday 分类：Asp.Net 2.0
在创建用户角色时，app_data文件下会自动生成ASPNETDB.MDF数据库，
如果你不想用自动生成的数据库可以通过修改Web.Config文件来实现，最好名字一样，不然在Asp.net配置那里会有点麻烦。
[codes=xml]
<connectionStrings>
<clear/>
<add name="LocalSqlServer" connectionString="Data Source=.;Initial Catalog=SocanCRM;Persist Security Info=True;User ID=sa;Password="
providerName="System.Data.SqlClient" />
</connectionStrings>
[/codes]
然后配置以下三个节点
[codes=xml]
<membership>
<providers>
<clear/>
<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="false" applicationName="SocanCRM" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
</providers>
</membership>
<profile>
<properties>
<add name="UserProfile" type="String" allowAnonymous="false" />
</properties>
<providers>
<clear/>
<add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="SocanCRM" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</profile>
<roleManager enabled="true">
<providers>
<clear/>
<add connectionStringName="LocalSqlServer" applicationName="SocanCRM" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</roleManager>
[/codes]
标签： 服务器 数据库 .net mssql-2005 c#