SQL Server Performance

Password Recovery

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

  1. aarvind1 New Member

    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?
  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.
  3. satya Moderator

  4. lucarichard96 New Member

  5. miteshaegis New Member

    To recover your Passwordin Oracle,

    SQL>conn / as sysdba
    SQL>alter user Username identified by PASSWORD;
  6. Luis Martin Moderator

    This is SQL SERVER Forum.

Share This Page