I am trying to set up a stand alone ADFS instance with a SQL attribute store. I have gotten ADFS 2.0 to work, but when adding a SQL store using integrated authentication, it cannot connect (the SQL server is on a separate server) because it is running as Network Service (I get the login failure as DOMAIN\server$ tried logging in).
Is there any way to set up a SQL store in a stand alone environment (using WID) with integrated authentication? I know you can specify credentials when installing a farm, but this option is not available when setting up a stand alone instance. (I am also not a domain admin so I can't set up a farm, and this is a POC so getting the domain admins involved will raise a lot of questions for a test.) I am trying to avoid using SQL logins.