Using a DotNetNuke auth database for a SharePoint FBA database

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

Setup SharePoint Forms Based Authentication (FBA) with Active Directory

This Article will explain how to set up Forms Based Authentication using an Active Directory backend.

Your default site is required to be a Windows Authentication provider. This is due to the fact that you the search and backup process will break if the default is anything other than a standard Windows provider.  This will require you to extend the existing site. Here is an example.

portal.domain.com —> extended to —> fba.domain.com

Windows login: portal.domain.com
FBA login: fba.domain.com

In our example we will be using the following typical variables which you will have to change to suit your particular needs in the appropriate web.config files.

Membership Provider name=”ENIGMA”
Role manager name=”ENIGMAROLE”
server=”domain.com”
userContainer=”DC=Domain,DC=com”

Continue reading