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

how to setup IIS to perform basic http authentication against MS SQL database (and not to use Windows domain)

The existing WS-Federated security is mapped to MS SQL database. We'd like to migrate to basic http authentication since it's simpler to users. However, I didn't found the way how to configure IIS to delegate to MS database.

share|improve this question

If your application is running in impersonate mode, with basic auth, I believe you could do this by telling your connection string to use the trusted connection, which means pass the credentials along.


trusted connection: *Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;* see

share|improve this answer

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.