Getting ASP.NET Membership running against your own database

If you want to install the ASP.NET V2 tables and procedures for things such as Membership, Personalization, etc you need to run the aspnet_regsql.exe tool against your database.  The tool can be found in the %windir%\Microsoft.NET\Framework\{FRAMEWORKVERSION} folder.

Once you've run that tool, then it's just a matter of replacing the ConnectionString entry in your web.config file to point to your database:

  <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

    <connectionStrings>
      <remove name="LocalSqlServer" />
      <add connectionString="CONN STRING" name="LocalSqlServer" providerName="System.Sql.DbClient" />
    </connectionStrings>

  </configuration>

After that, the built-in API's will read and write from your database for that application.