how to Integrate Windows Authentication w

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I like to know if it is possible to integrate windows authetication with ASP. Basically, the Domain Controller will be the repository for all user logon ids and passwords. I have read about the Authentication methods in IIS, that has basic authentication, windows integrated authentication. However, this seems like a website level authentication. 

1) There will be a database involved holding sensitive data. 
2) I would like to restrict access to only data that belongs to that individual who logged on. 
3) I do not want to restrict access to only local network where the domain controller resides. That means they can logon anywhere that has internet access.
4) I also need a way to pass the value of what was being typed in as User ID to the ASP page, so that i can reference in the database what to query

If all i am using is Integrated authentication in IIS5.0, does that mean that anyusers can access anydata in the Database? How can they do that?

any sugguestions will be appreciated. 
Thanks 