Opt Powerful Solution To Resolve The Quest How To Reset Sql Password
Mssing passwords of some confidential document or database is not a big issue now days, it often happens with everyone because users have lots of work to do so how it is possible to keep in mind all the things. Suppose, being a SQL Server user you forget the SA password of SQL Server. Now, query roaming in your mind is how to reset SQL password efficiently without losing a single data item from SQL database. You do not need to worry about it, beneath mentioned some efficient measures to reset SQL database password:
1.Reset SQL Password From The Command Prompt
Go to command prompt by following Start-->Run, after that type cmd.exe in the Run dialog box
Use C:MSDEbinn, C:Program FilesMSSQLbinn or other well known command to change the directory where MSDE utilities are stored
Type the given command for applying new password where is the new password:
sql -U sa -P "" -Q "sp_password NULL, < password1>, sa"
2.Change SA Password On The SQL Server Side
Set services log of SQL Server under a dissimilar user account
In the Start menu, direct to Settings, and then click Control Panel.
Double-click on Services tab.
Double-click on MSSQLServer, SQLServerAgent, or MSDTC. It is needed to update information for all these services.
In the Services dialog box, go to the Login area, select account then, enter or update the account information.
Click OK then, click Close.
Note: If Microsoft Full-Text Search is installed in your computer then, it is not needed to change the MSSQLServer account information in the Services application of Control Panel. SQL Server users know that the Search service is assigned to the local system account; still it keeps track of MSSQLServer service account. It is important to update the MSSQLServer service account in SQL Server Enterprise Manager for the Microsoft Search services to utilize perfect synchronization.
If both of above mentioned methods do not did well for you then, follow the third and most effective method mentioned beneath:
3.Utilize Powerful Tool To Reset SQL Password
If you are not satisfied with both of the solutions given above then purchase an intelligent and effective Unlock SQL Server password Tool for recovering database of Microsoft SQL Server 2000/2005/2008. Like SQL Password Recovery software of our organization that works instantly to reset SQL passwords. Moreover, it efficiently resolves all the doubts and queries of users involving query how to reset SQL password.
1.Reset SQL Password From The Command Prompt
Go to command prompt by following Start-->Run, after that type cmd.exe in the Run dialog box
Use C:MSDEbinn, C:Program FilesMSSQLbinn or other well known command to change the directory where MSDE utilities are stored
Type the given command for applying new password where is the new password:
sql -U sa -P "" -Q "sp_password NULL, < password1>, sa"
2.Change SA Password On The SQL Server Side
Set services log of SQL Server under a dissimilar user account
In the Start menu, direct to Settings, and then click Control Panel.
Double-click on Services tab.
Double-click on MSSQLServer, SQLServerAgent, or MSDTC. It is needed to update information for all these services.
In the Services dialog box, go to the Login area, select account then, enter or update the account information.
Click OK then, click Close.
Note: If Microsoft Full-Text Search is installed in your computer then, it is not needed to change the MSSQLServer account information in the Services application of Control Panel. SQL Server users know that the Search service is assigned to the local system account; still it keeps track of MSSQLServer service account. It is important to update the MSSQLServer service account in SQL Server Enterprise Manager for the Microsoft Search services to utilize perfect synchronization.
If both of above mentioned methods do not did well for you then, follow the third and most effective method mentioned beneath:
3.Utilize Powerful Tool To Reset SQL Password
If you are not satisfied with both of the solutions given above then purchase an intelligent and effective Unlock SQL Server password Tool for recovering database of Microsoft SQL Server 2000/2005/2008. Like SQL Password Recovery software of our organization that works instantly to reset SQL passwords. Moreover, it efficiently resolves all the doubts and queries of users involving query how to reset SQL password.
Source...