SQL Server Performance

Log in or Sign up

Password Recovery

Discussion in 'SQL Server 2005 General DBA Questions' started by aarvind1, Jul 9, 2010.

aarvind1 New Member

Hello,
I have an account on a SQL 2005 server that consultants created 2 years ago. I don't seem to have the password for this account. I need to recover the password. I can't simply change it as it is used by an Oracle application. Is there a way to recover this password?
Thanks,
Sachin

aarvind1, Jul 9, 2010

#2
ashish287 New Member

If you have enough permission on sql server, why not forget about that account and create new with same permissions. It will be easy for you to manage.

ashish287, Jul 11, 2010

#3
satya Moderator

I don't generally recommend freeware tools for production unless tested, as it is one-off need to change the password you can help of http://www.freedownloadscenter.com/Utilities/Password_Management_Utilities/SQL_Password.html tool in this case.
If you can find out where else this login has been used & hard-coded the password, you could follow what Ashish referred.

satya, Jul 12, 2010

#4
lucarichard96 New Member

I also find a good software for resetting SA password on google. - http://www.softpedia.com/get/System/Back-Up-and-Recovery/SQL-Server-Password-Changer.shtml

lucarichard96, Mar 5, 2012

#4
miteshaegis New Member

To recover your Passwordin Oracle,

SQL>conn / as sysdba
SQL>alter user Username identified by PASSWORD;

miteshaegis, Nov 30, 2012

#5
Luis Martin Moderator

miteshaegis said: ↑

To recover your Passwordin Oracle,

SQL>conn / as sysdba
SQL>alter user Username identified by PASSWORD;

This is SQL SERVER Forum.

Luis Martin, Nov 30, 2012

#6

(You must log in or sign up to reply here.)

Share This Page