I would like to have a solution for the following problem
Database:SQL Server 2000 and SQL Authontication
Web Server:IIS and the application is developed in ASP.
I have in my database the login name (but not the password) to access the site. And this login name is just the same as the the one I use for my windows authontication. I would like to use valid windows authontication information of user and store his password in the table in the db against that username (which is already there in the database). The storing of password is essential becuase if the same user accesses the site over internet (not from intranet), he will supply the username and password and gain access to the site by validating from db.
Therefore, when ever user logs on to the application within the intranet he will be authonticated against his windows logon information and password is updated in the db and when he is accessing the site from outside intranet (over inetenet) he will have the access to site by providing login name and passwod at the index page and get the access if he is valid user.
Is this possible?
If so what should I do? Any lead to this kind of situation.
Thanks in advance
Sam
Database:SQL Server 2000 and SQL Authontication
Web Server:IIS and the application is developed in ASP.
I have in my database the login name (but not the password) to access the site. And this login name is just the same as the the one I use for my windows authontication. I would like to use valid windows authontication information of user and store his password in the table in the db against that username (which is already there in the database). The storing of password is essential becuase if the same user accesses the site over internet (not from intranet), he will supply the username and password and gain access to the site by validating from db.
Therefore, when ever user logs on to the application within the intranet he will be authonticated against his windows logon information and password is updated in the db and when he is accessing the site from outside intranet (over inetenet) he will have the access to site by providing login name and passwod at the index page and get the access if he is valid user.
Is this possible?
If so what should I do? Any lead to this kind of situation.
Thanks in advance
Sam
