Can I use ADFS 2.0 to authenticate certain users against SQL Server?

by

AD FS 2.0 can only authenticate against Active Directory (AD DS). This is not explicitly documented in the official AD FS 2.0 documentation, but it follows from the following two snippets:

So no custom authentication stores, SQL Server based or otherwise.

(On the other question on additional attribute stores: that is possible.)

The solution that is suggested in an answer to the other question you refer to is a bit misleading. If you read the actual blog post you see that they add an extra STS. AD FS 2.0 has a ‘Claims Provider Trust’ for that other STS, and redirects to it (if the ‘home realm discovery’ is set up correctly). That other STS then performs the authentication in whichever way it likes, sends a token back to AD FS, which then runs its claim rules.

So in that solution it is not AD FS 2.0 authenticating against an non-AD store, but redirecting to an STS which authenticates against that store.

More Related Contents:

  1. How can I round a value in SQL
  2. How do I update a value in C# and SQL Server? [closed]
  3. SQL Server Char/VarChar DateTime Error [closed]
  4. How to get last inserted id?
  5. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  6. Execute Insert command and return inserted Id in Sql
  7. Adding multiple parameterized variables to a database in c#
  8. Getting return value from stored procedure in C#
  9. SQL error: Incorrect syntax near the keyword ‘User’
  10. What represents a double in sql server?
  11. SQL WHERE clause matching values with trailing spaces
  12. Query extremely slow in code but fast in SSMS
  13. SqlBulkCopy from a List
  14. Code to validate SQL Scripts
  15. SQLException : String or binary data would be truncated
  16. Multi threading C# application with SQL Server database calls
  17. SqlConnection.Close() inside using statement
  18. Generate class from database table
  19. ALTER TABLE DROP COLUMN failed because one or more objects access this column
  20. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  21. What is passing parameters to SQL and why do I need it?
  22. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  23. Add WHERE clauses to SQL dynamically / programmatically
  24. How to pass string array in SQL parameter to IN clause in SQL
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. How to insert data into SQL Server
  27. Query validation using C#
  28. Database Error: There is no row at position 0
  29. Generating sql code programmatically
  30. Capturing count from an SQL query

Leave a Comment