Setting up membership for your ASP.Net website is pretty simple. All you need to do is:
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>
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>
Then load up the Web Site Administration Tool by going to Website\Asp.Net Configuration in VS2005.
You will then be about to configure your membership using SQL2000/2005 using this tool.
So where is the gotcha you might ask? Well, if you try to name your connection string anything other than LocalSqlServer, when you get to the provider tab you will see a message that says "No Provider Created". This is why you need to clear out the connection string section using the <clear/> tag so that you can override the setting in the machine.config.
I hope that helps someone.
Happy Programming
Doc