Theme Graphic
Theme Graphic

sql server password recovery

the ways to reset sql password you have forgot or lost on ms sql server
Posted on Thursday, January 07, 2010 at 1:47 AM

How to change your system administration password if you forget your SQL password?


How to change your system administration password if you forget your SQL password?


Look, there are so many similar questions:
How to reset sa password ?
"How to change SQL password without data loss?"
"I've forgotten the sa password for SQL Server - what can I do?"
"How to Change SA Password If Forgot or Lost SQL Password?"
...

In fact, two sql password recovery solutions can help solve those problems. The simplest method is to take use of the SQL password recovery tool, and MS SQL Server Password Unlocker is highly recommended by MS SQL Server users. MS SQL Server Password Unlocker helps to decrypt the master.mdf and resets the lost MS SQL password, including changing sa password. This MS SQL password recovery program has small size yet with a powerful numeracy; it resets sa passwords of any length and complexity with no fussy settings. Just one mouse clicking to reset the selected SQL passwords.Whether or not the SQL Server is installed in advance, MS SQL Server Password Unlocker accesses to the master.mdf file directly and lists all the users to the database. For accessing the master.mdf smoothly, the password recovery program detects and stops the running SQL Services automatically.

Besides, you can also reset sa password without any program; just a few Command can work it. As following,
On the computer that is hosting the instance of MSDE to which you are connecting, open the command prompt window.
Type the following command, and then press ENTER:osql -U saAt the Password: prompt, press ENTER if your password is blank or type the current password. This connects you to the local, default instance of MSDE by using the sa account. To connect by using Windows authentication, type this command: use osql -ENote If you are using SQL Server 2005 Express, avoid using the Osql utility, and plan to modify applications that currently use the Osql feature. Use the Sqlcmd utility instead.For more information about the Sqlcmd utility, visit the following Microsoft Developer Network (MSDN) Web site:
Type the following commands, on separate lines, and then press ENTER:sp_password @old = null, @new = 'complexpwd', @loginame ='sa' go
Note Make sure that you replace "complexpwd" with the new strong password. A strong password includes alpha-numeric and special characters, and a combination of upper and lower case characters.
You will receive the following informational message, which indicates that your password was changed successfully:
Password changed.

Reference: http://blog.passwordunlocker.com/how-to-change-your-system-administration-password-if-you-forget-your-sql-password/  
Bookmark: Submit To Digg Submit To reddit Submit To del.icio.us Bookmark With StumbleUpon Bookmark With FaceBook Bookmark With Google Bookmarks   Share: Share By Email By Email

1 comments on "How to change your system administration password if you forget your SQL password?"
Posted by rekey on Monday, October 11, 2010 at 8:32 PM
Image Of Author
how to unlock your sql server 2000/2005/2008 passwprd
MS SQL Server Password Unlocker is handy SQL password recovery software for you to reset SQL password including reset SA password and other user passwords. It can easily reset SQL password for Microsoft SQL Server 2000/2005/2008 in a minute. You don’t need to install MS SQL Server on your PC, and the file in master.mdf format is enough for you to reset SQL password.

Leave A Comment
Subject:


Comment:
   Bold Italic Underline          Code Link Image Horizontal Rule


Because you do not have or are not logged in to your Programmer's Heaven account, please enter your name.

Name:


To help prevent comment SPAM, please enter the magic code '514' in the box:




Posting Rules
Please follow these rules when posting comments on blog posts.
  • Do not post anything that is racist, hate speech or of a sexual or adult nature.
  • Do not post or link to anything that infringes copyrighted laws.
  • Posting about security or legal topics is fine so long as you are not glorifying or encouraging people to perform illegal activities.
  • Both the author of this blog and the Programmer's Heaven administrators may delete any inappropriate comments without notice at their own discretion.
 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.