I hope you are all well and can assist.
We are looking at setting up our ADFS environment, and wish to use SQL Server 2008 as our adfs database.
This will be on 2008 R2 SQL Server, and we wish to create a new sql instance on this server for adfs.
What I would like to know is the following:
1) What are the requirements in terms of SQL instance configuration adfs requires?
eg.collation set etc
2) Any other help greatly appreciated in determining what, from a sql database point of view, are the configuration things we need to make sure get done for adfs to work.
An example below I got online is this:
FSConfig.exe CreateSQLFarm /ServiceAccount pipe2text\adfslabuser /ServiceAccountPassword Password /SQLConnectionString “database=AdfsConfiguration;server=sqlservername\instance;integrated security=SSPI” /CleanConfig /FederationServiceName adfs.pipe2text.com /AutoCertRolloverEnabled
What I dont understand is the following:
Does the SQL instance have to be created first?
Im assuming it does, and if this is the case, what collation set etc is needed?