Forum Discussion

  • VJware's avatar
    VJware
    Level 6
    10 years ago

    This is a query to be asked of either a SQL DBA or Microsoft.

  • johnwalker10's avatar
    johnwalker10
    Level 2
    10 years ago

    To recover lost SQL admin password you can try advanced SQL Password Recovery Tool. The software is capable to recover all kind of passwords like numeric, alphabetical, special character too. The software supports MS SQL Server 2008 and all the below versions.

    Read More: - http://www.sqlpasswordrecovery.repair-sql.net/

     

  • Poonam_R's avatar
    Poonam_R
    10 years ago

    Before using any password recovery tool, its better to apply some manual effort. Here, I am dicussing a points through which you can reset the SQL SA password.

    Use Command Prompt:

    • Go to the command prompt of the server and type in command prompt osql –L
    • Copy full name of SQL Server and type: OSQL -S <insert_servername_here> -E
    • Execute the following query: sp_password NULL, ‘<insert_new_password_here>’, ’sa’
    • GO

    Else, you can use the online available tools to recover the password. Take an example of this SQL Password Recovery Tool. The tool support all MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, and compatible with all major Operating Systems of Windows,