I have used the aspnet_regsql tool with the "-E -A all" options on one of the databases for my site. In my web.config file, I have the following:
<anonymousIdentification enabled="true"/>
<profile defaultProvider="BTPSqlProfileProvider" enabled="true">
<providers>
<clear />
<add name="BTPSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider"
connectionStringName="BTPUsersConnStr" />
</providers>
  ...
Go to the complete details ...