How to integrate Active Directory and SQL Server for authenticating users to access the application.
lunes, 16 de abril de 2012 9:55
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.
Todas las respuestas
martes, 17 de abril de 2012 2:19Moderador
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.
Hope this helps.
martes, 17 de abril de 2012 4:26
Thanks for your reply.
Yes , i have a user table in sql server having user name and password and i want to authenticate some user through that.
How to create a custom STS with federation authentication ?
Can i use SQL azure inplace of on premise sql server to do that ?
- Editado var9287 martes, 17 de abril de 2012 4:27
martes, 17 de abril de 2012 5:01Moderador
Just create a WIF STS website, and this is a empty anthentication site, you have to add your code logic to authenticate users' info and give a response.
Yes On-premise sql server can also works for your custom STS, but you need to make sure cross-domain request works in your sample and VM.
If you want a full sample code to show how to do that, try to post your sample request to Microsoft All-In-One Code Framework, i believe they will give a quick response to you.
Hope this helps.
martes, 17 de abril de 2012 7:51
Can you show how to achieve this ?
I am still not getting it.
martes, 17 de abril de 2012 8:47Moderador
But you should create your own STS for SQL Server authentication.
Hoep this helps.
martes, 17 de abril de 2012 10:45
I have created a project in which 'Default.aspx' is my home page
I referred to http://www.developerfusion.com/article/121561/integrating-active-directory-into-azure/ article for authenticating through active directory. It works like when a user enter my url a pop up show which ask's for user name and password which are checked in on-premise active directory.
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.
Please reply what to do ?