I just forgot the password. Can anyone help me how to get back the password.
This question is related to
sql-server
sql-server-2005
passwords
MSSQL have its own database management tool called as "MSSQL Server Management Studio (SSMS)". Here are steps to reset SA password using SSMS :
1] Open SSMS management console, it will prompt for authentication details,
Select Server Type : "Database Engine", Server name : IP / hostname of your MSSQL server Authentication : Windows Authentication
Once you select Authentication type as "Windows Authentication", the user name and password fields will be grayed out and it will allow you to login SQL server without entering login details. Windows Authentication is possible only when you are logged on same server in RDP on which SQL service is present.
2] once you are in, under "Object Explorer" expand Security and then Logins 3] locate and right click on user SA and select Properties 4] under General section enter desired password in front of "Password:" and "Confirm Password:" 5] hit OK at bottom.
This is the easiest and secure way to reset SA password instead of using any third party non secure tools
Granted you have administrative Windows privileges on the server, another option would be to start SQL Server in Single User Mode, using the Startup parameter "-m". Doing this, you can login using SQLCMD, create a new user and give it sysadmin privileges. Finally, you have to disable Single User Mode, login to SSMS using your new user, and go to Segurity/Logins and change "sa" user password.
You can check this post: http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/
MSSQL have its own database management tool called as "MSSQL Server Management Studio (SSMS)". Here are steps to reset SA password using SSMS :
1] Open SSMS management console, it will prompt for authentication details,
Select Server Type : "Database Engine", Server name : IP / hostname of your MSSQL server Authentication : Windows Authentication
Once you select Authentication type as "Windows Authentication", the user name and password fields will be grayed out and it will allow you to login SQL server without entering login details. Windows Authentication is possible only when you are logged on same server in RDP on which SQL service is present.
2] once you are in, under "Object Explorer" expand Security and then Logins 3] locate and right click on user SA and select Properties 4] under General section enter desired password in front of "Password:" and "Confirm Password:" 5] hit OK at bottom.
This is the easiest and secure way to reset SA password instead of using any third party non secure tools
Wait!
There is a way to retrieve the password by using Brute-Force attack, have a look at the following tool from codeproject Retrieve SQL Server Password
To Retrieve the password of SQL Server user,run the following query in SQL Query Analyzer
"Select Password from SysxLogins Where Name = 'XXXX'" Where XXXX is the user
name for which you want to retrieve password.Copy the password field (Hashed Code) and
paste here (in Hashed code Field) and click on start button to retrieve
I checked the tool on SQLServer 2000 and it's working fine.
Granted you have administrative Windows privileges on the server, another option would be to start SQL Server in Single User Mode, using the Startup parameter "-m". Doing this, you can login using SQLCMD, create a new user and give it sysadmin privileges. Finally, you have to disable Single User Mode, login to SSMS using your new user, and go to Segurity/Logins and change "sa" user password.
You can check this post: http://v-consult.be/2011/05/26/recover-sa-password-microsoft-sql-server-2008-r2/
Wait!
There is a way to retrieve the password by using Brute-Force attack, have a look at the following tool from codeproject Retrieve SQL Server Password
To Retrieve the password of SQL Server user,run the following query in SQL Query Analyzer
"Select Password from SysxLogins Where Name = 'XXXX'" Where XXXX is the user
name for which you want to retrieve password.Copy the password field (Hashed Code) and
paste here (in Hashed code Field) and click on start button to retrieve
I checked the tool on SQLServer 2000 and it's working fine.
Source: Stackoverflow.com