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 "adfsserver.domain.com" /CleanConfig /AutoCertRolloverEnabled Here is an example of my lab configuration: Finally, the help information is only