Using SQL Server 2005/2008 with ADFS 2.0

If you plan on using a SQL server 2005/2008 to host your ADFS 2.0 configuration database you must run the configuration using the command line.  If you use the GUI configuration SQL Server Express will be installed on the machine and used to host the database.

Below is an example of a configuration command that would set the service account, create the database and wipe out any information if it already exists, and to use self signed certificates.

Open a command prompt and navigate to:
C:\Program Files\Active Directory Federation Services 2.0

Run the following command:
FSConfig.exe CreateSQLFarm /ServiceAccount "domain\user" /ServiceAccountPassword "password" /SQLConnectionString "database=AdfsConfigurationServer;server=sqlservername;integrated security=SSPI" /port 443 /FederationServiceName "" /CleanConfig /AutoCertRolloverEnabled

Here is an example of my lab configuration:

Finally, the help information is only available through the command line. below is a screen shot of the full output.

MSDN - Configure a New Federation Server


Popular posts from this blog

Add User As Local Administrator On Domain Controller

An error occurred while applying security information to

Horizontally Scroll A Large Power Apps Gallery