SQL provider 폼인증 web.config 설정

http://www.codeproject.com/KB/sharepoint/FBA.aspx

web.config 설정

<connectionStrings>

    <add name="FBA_SqlConnectionString"

         connectionString="server=sharepoint;database=FBAASPNetDb;Integrated Security=SSPI;"

         providerName="System.Data.SqlClient"/>

  </connectionStrings>

 

 

<membership defaultProvider="FBA_AspNetSqlMembershipProvider" userIsOnlineTimeWindow="15">

      <providers>

        <!--LDAP Provider-->

        <add name="FBA_AspNetSqlMembershipProvider"

             type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.3600.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"

             connectionStringName="FBA_SqlConnectionString"

             enablePasswordRetrieval="false"

             enablePasswordReset="true"

             requiresQuestionAndAnswer="false"

             applicationName="/"

             passwordFormat ="Hashed"

             maxInvalidPasswordAttempts="5"

             minRequiredPasswordLength="1"

             minRequiredNonalphanumericCharacters="0"

             passwordAttemptWindow="10"

             passwordStrengthRegularExpression=""          

             />

      </providers>

    </membership>

    <!-- role provider-->

 

        <roleManager enabled="true" defaultProvider="FBA_AspNetSqlRoleProvider">

      <providers>

        <add name="FBA_AspNetSqlRoleProvider"

            type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

             connectionStringName="FBA_SqlConnectionString"

             applicationName="/"

             />

      </providers>

    </roleManager>