ASP.NET Forms Authentication integrate with SQL Server

Question

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

Mitchel Sellers · Accepted Answer · 2011-01-14 18:33:10Z

1

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.

answered Jan 14, 2011 at 18:33

Mitchel Sellers

63.3k15 gold badges115 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

prama Over a year ago

OK, there is a way to integrate the authentication? Without pass parameters. For example, in SQL Server will SYSTEM_USER is the authenticated user in AD.

Alexander Beletsky · Accepted Answer · 2011-01-14 18:34:35Z

1

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

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

answered Jan 14, 2011 at 18:34

Alexander Beletsky

19.9k10 gold badges65 silver badges86 bronze badges

Collectives™ on Stack Overflow

ASP.NET Forms Authentication integrate with SQL Server

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related