I want to integrate both active directory and sql server 2008 for authenticating users for my application running on azure platform .This is because not all user records are in active directory , some users will be authenticated from sql server 2008.
I am able to authenticate users in active directory using Access control service of windows azure , need the same with sql server 2008 also.
Solution for this is very important for my application to run.
How do do anthenticating users by SQL Server? is that mean you have a user table in SQL database and want to authenticate users by their username/Password?
I think if you have ever enable ACFS in ACS, you can create another custom STS with Federation Authentication, this STS will access your SQL Server, and return SAML token to ACS, if user info is matched, pass the authentication, if not, refuse users.
After that i added a new page called 'login.aspx' in my project, with couple of text boxes and a login button to authenticate through sql azure table.This Table contains columns for name and password.This is for the user's who's name and password are stored
in sql azure.
I also created a check box here which will re-direct to 'Default.aspx' for the users, who exist in active directory.
I set Login.aspx as my home page.
when i run my project , still a popup for active directory authentication is showing automatically.