SQL password field

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?
LVL 1
techbotsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
Log into the server with SQL Server installed and then from the command line run ssms using psexec.  This will log you into SSMS AS NTAuthority user which automatically has sysadmin rights on the sql instance.  At that point you can change any passwords you need including sa.  This assumes you have admin rights on the server.

PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/
0
techbotsAuthor Commented:
I don't believe I have that kind of access. This is hosted on godaddy.  I can log onto the database. What I need is to change a password field within a table of the database.
0
techbotsAuthor Commented:
Is there a simple way to just encrypt a word and copy and paste it into the field?
0
Randy Knight, MCMPrincipal ConsultantCommented:
You would need to know how the application is encrypting / decrypting the password.  Do you have access to the ASP.NET code?  If you can see what they are doing to encrypt the password, you should be able to encrypt a clear text password using the same method, then update the password field in the database with the hash.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
techbotsAuthor Commented:
I hunted through all the ASP.NET code and found where the password was being encrypted but had no idea how to encrypt a new one so I just changed the code for just a second so I could log in with a plain text password. Not ideal, but worked enough for me to do what I needed.

Thanks for pointing me in the right direction - I won't bother you with asking further instructions since I found a temporary work-around. I learned I need to learn a lot more about ASP.NET & SQL Server!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.