While there are a fair number of sites outline how to set up a Forms based authentication (FBA) front end using an new empty SQL database. An excellent one by my co-worker Corey Burke at Rackspace is SharePoint Voodoo: Easy-Bake Forms Based Authentication. There are none that outline the process of using a new FBA with an existing DotNetNuke authentication database.
1. Create your FBA site with a new blank FBA database back-end. For this purposes I will call the FBA database ‘FBA-DB’ and the DotNetNuke database as ‘DNN-DB’.
In this instance we were lucky because both database bases use a standard authentication database from Microsoft when the aspnet_regsql command is used. When we create a blank FBA database it will have the standard database structure like the one pictured below. Continue reading