How to integrate Active Directory and SQL Server for authenticating users to access the application.

Question

Hello ,

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.

Kindly Reply.

Solution for this is very important for my application to run.

Thank You

Answer 1

Hi,

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.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 2

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 ?

Answer 3

Hi,

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.

http://1code.codeplex.com/workitem/list/basic

Hope this helps.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 4

Can you show how to achieve this ?

I am still not getting it.

Answer 5

Refer to:

http://msdn.microsoft.com/en-us/wazplatformtrainingcourse_windowsazureandpassivefederation2010_topic2#_Toc310436988

But you should create your own STS for SQL Server authentication.

Hoep this helps.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 6

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 ?