Tuesday, April 29, 2014

Reset Lost SA Password in SQL Server 2008 Express

Lost or forgot your SA password? The SA account got locked out or disabled after too many login attempts? Don't panic. With SQL Server Password Changer you can reset SA password and unlock your SQL Server account easily. In this tutorial I'll show you how to unlock / reset SA password in SQL Server 2008 Express.

How to Reset SA Password in SQL Server 2008 Express?

The SA login is stored in the master database (master.mdf) file, but this file is inaccessible while SQL Server is running. To unlock SA account in SQL Server, you need to first stop your SQL Server instance, and then install SQL Server Password Changer on your local computer.

Start the SQL Server Password Changer program. Click on Open File button and select the master database (master.mdf) for your SQL Server instance. By default, the master.mdf file resides in the following location:

C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA

After you've chosen the master database file, the program will analyze the file format and extract all database users from it. Choose the SA account and click on Change Password button. In the pop-up window, enter your desired new password and click OK.

The program will assign your new password to the SA account, and also enable / unlock the SA account when it is disabled or locked out. Start your SQL Server instance and you can then successfully connect to your SA account using your new password. Done!

Monday, April 14, 2014

How to Bypass Windows 7 Password without CD

Forgot your Windows 7 administrator password and don't have a CD or USB drive at hand? In this tutorial we'll show you a simple way to Bypass Windows 7 password without CD.

Of course, if you do have a PCUnlocker Live CD, you can bypass your password the easy way with a few mouse clicks. The following trick works with local account only. If you're using a Microsoft Account to login to your computer, you can also use PCUnlocker to reset lost Microsoft Account password.

How to Bypass Windows 7 Password without CD?
  1. Turn on your computer. While the computer is coming up and you can see it saying "Starting Windows". Hold down the Power button for at least 5 seconds to force power off your computer.
  2. When a sudden power loss is detected, the next time you turn on your computer and it will ask you if you want to launch startup repair or start normally. Choose the Launch Startup Repair (recommended) menu.
  3. Startup Repair will boot up and take a little while. When it asks you if you want to restore your computer to an earlier point, click Cancel.
  4. The Startup Repair Tool begins analyzing startup log files for clues as to the source of the problem and then launches a series of diagnostic tests to determine the cause of the startup failure. After a long time, you will get a dialog saying that Startup Repair cannot repair this computer automatically! Click on View problem details.
  5. Now scroll down to the end of the Detail Report. Click on the last link to read Microsoft's offline privacy statement.
  6. Notepad will come up with the privacy statement in it. Click on the File menu and then Open.
  7. In the File Open dialog box, change the Files of type option to All Files. Browse to the Sticky Keys application – C:\windows\system32\sethc.exe. Rename this file as a backup file: I named it "sethc-copy".
  8. Now find the cmd.exe file in the same folder. This is your Command Prompt. rename it to sethc.exe. Then close out of all the dialog boxes and Finish, so that the computer restarts.
  9. Once you get to the Windows login screen, hit the Shift key 5 times and it will open the Command Prompt window instead of the Sticky Keys application.
  10. Now to reset the password – just type the following command, replacing the username and password with the combination you want:
    reset user top-password.com 123456
  11. Close the Command Prompt and you should be able to log on to Windows with your new password.
That's it! You've successfully bypass Windows 7 password without a CD.