Using Sql Server 2000 Username/Password/Roles with ASP.Net 2.0 ?

[Luqman]

I want to use Sql Server Roles, Sql Server Logins/Passwords with ASP.Net
2.0, instead of saving One username/password in Connectionstring of
Web.Config, is it possible ?

Any example will be highly appreciated ?

If the sql Server user has the particular role, he can access that table
data other wise not.

Best Regards,

Luqman

 

[Brad Kingsley]

This is a bit dated of an article, but does it help?

http://www.orcsweb.com/articles/form_auth_db.aspx


~Brad Kingsley
MCSE, ASPInsider

http://www.orcsweb.com/
Managed Complex Hosting
#1 in Service and Support