Setting up membership for your ASP.Net website is pretty simple. All you need to do is:

1.  run the scripts using the aspnet_regsql.ext tool (C:\WINDOWS\Microsoft.Net\Framework\v2.0.50727\aspnet_regsql.exe    your version number may be diferent) to set up the database tables.
2. Add a membership section to your web.config. Making sure that you add the <clear/> tag since you need to override the machine.config.
   
   

      41     <membership>

      42       <providers>

      43         <clear/>

      44         <add name="AspNetSqlMembershipProvider"

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

      46                   connectionStringName="LocalSqlServer"

      47                   enablePasswordRetrieval="false"

      48                   enablePasswordReset="true"

      49                   requiresQuestionAndAnswer="true"

      50                   applicationName="/"

      51                   requiresUniqueEmail="false"

      52                   minRequiredPasswordLength="1"

      53                   minRequiredNonalphanumericCharacters="0"

      54                   passwordFormat="Hashed"

      55                   maxInvalidPasswordAttempts="5"

      56                   passwordAttemptWindow="10"

      57                   passwordStrengthRegularExpression="" />

      58       </providers>

      59     </membership>

      60   </system.web>
   
   

3. Add a connection string once again using the <clear/>  tag to clear out the machine.config settings. (I will tell you why soon) 
   
   

      16   <connectionStrings>

      17     <clear/>

      18     <add name="LocalSqlServer" connectionString="Data
                Source=xxx;Initial Catalog=xxx;Persist Security
                Info=True;User ID=xxxx; password=xxx" />

      19   </connectionStrings>
   
   
   

4. Then load up the Web Site Administration Tool by going to Website\Asp.Net Configuration in VS2005.

5. You will then be about to configure your membership using SQL2000/2005 using this tool.