Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
up vote 1 down vote accepted

It doesnt seem to be possible to create a login for a computer using SQL studio GUI option (disclaimer I am no SQL guy). But I tried using Transact-SQL to do this and made a login. Used following syntax

CREATE LOGIN [<domainName>\<computername$>] FROM WINDOWS; GO

Replace computer and domain name as applicable.

If you define access to the database for this login, you may be able to use as an attribute store while using standalone option. Please report back if this fails.

share|improve this answer
I can't since I don't have domain admin privileges, and to set up a farm you need to be able to create AD objects. It looks like I will be stuck using either a connection string login or getting the domain admins involved. – Brian Aug 5 '11 at 15:34
I've updated my answer based on a new method to create a login to represent a computer. I hope it helps. – maweeras Aug 5 '11 at 18:53
I will give it a shot shortly and see if it works. – Brian Aug 8 '11 at 20:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.