There are many reason for having to setup the SQL Membership tables (schema) once again. In my case I changed hosting environments and because I was still in testing phase there was no need for a backup and restore strategy instead I just needed to recreate the membership tables in the new SQL Server (2008).
The easier way I found was:
1) Open Visual Studio Command Prompt (VS2008 for me)
2) type “aspnet_regsql.exe“, this will open the “ASP.NET SQL Server Setup Wizard”, click Next.
3) Choose to “Configure SQL Server for application services”. Next.
4) Enter your server name, choose the correct authentication and choose the Db for your Membership tables. Note: I created the Db before starting the Wizard that way I can test connection and make sure is working fine. Click Next. That’s it.