I inherited a website for a client after their developer bailed & disappeared. The site is in ASP.NET using an MS SQL database. The client does not remember the password to their admin area. I can access the database through the web host control panel. I can see the login username & password fields, but the password is encrypted.
How do I set a new password? Plain text doesn't work obviously. I assume I need to encrypt it, but how?