I have an asp.net application I've written which queries data from a sql 2005 database.
The main page is a generic interface which anyone should be able to access. I am using forms authentication and the first page does not require anyone to login.
If they access the "Admin" page is shows them the login.aspx page. What I am trying to do is on that page that they logged into have the credentials that they authenticated with be used against the SQL queries rather than using embedded username / passwords impersonation within the web.config page .
Suggestions?
Also, I am using Active Directory for my membeship provider to authenticate the user when they access the login.aspx page.
...
Go to the complete details ...