Changing password at runtime
Posted on 2007-11-13
I have my VB.NET application, developed with visual web developer, which access SQL Server DB using connection strings defined in the web.config file.
Now, I have to give the user, ability to change their passwords of their SQL Server DB accounts. I can throw them a screen asking them to change their passwords but how can I propogate the new password to the database and make the changes in the SQL Server itself?