ASP.NET Forms Authentication integrate with SQL Server

2
votes

I have a follow scenario:

SERVER 1 - IIS6 ASP.NET Web Application with Forms Authentication on Active Directory

SERVER 2 - SQL SERVER Database

How i can integrate the security of Forms Authentication AD with SQL Server?

My objective is use Forms AD authentication and integrate the user authenticated for get data profile.

Ex: SELECT * FROM [TABLE] WHERE [TABLE].[USER] = SYSTEM_USER

2
asp.netsql-serverauthenticationactive-directoryforms-authentication

2 Answers

1
votes

You can use the

User.Identity.Name

to get the username of the currently logged in user and pass that via a parameter to the database query that you use.

1
votes

You should confire your application for SQL Membership provider. Some information here:

http://technet.microsoft.com/en-us/library/cc197472(office.12).aspx