Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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.

impersonation: http://msdn.microsoft.com/en-us/library/aa292118(v=vs.71).aspx

trusted connection: *Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;* see http://www.connectionstrings.com/sql-server-2008

share|improve this answer

Your Answer

 
discard

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.