cancel
Showing results for 
Search instead for 
Did you mean: 

Reset SQL Server SA Password

Alexfranky
Level 2

HI,

 

I have used SQL Server last few years but accidently i lost my last admin paswword. How to fix it ?

3 REPLIES 3

VJware
Level 6
Employee Accredited Certified

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

johnwalker10
Level 2

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
Not applicable

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,