Can i access SQL Login Users in ASP.Net application

Hello All,

I have SQL Server 2005 Installed and i have numbers of SQL Logins users which i want to use in my ASP.Net Application for authentication.

I am using ASP.Net 2.0 (VS.Net 2005).

Can i use the SQL Logins for ASP.Net web application authentication like the way we use Active Directory users?
Thanks in advance,
Wajahat Abbas
http://www.wajahatabbas.com

SQL Authentication is specific to SQL. You will not be able to use SQL Logins as you use Windows users.

See also:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconaspnetauthentication.asp

Thanks
Laurentiu

|||

Thanks for replying.

Ya, i was thinking that with SQL 2005 and ASP.Net release, MS will increase the ASP.Net authenticaiton modes.

As SQL Server 2005 provides very cool features for SQL Users (like bad password, rating), so once we able to consume those things in ASP.Net it would be a peice of cake.
Anyway may be in next releases.

Thanks & Regards,
Wajahat Abbas
http://www.wajahatabbas.com
http://www.dotnetpakistan.com