sponsored ads

I lost sql server password, how i can reset sql sa password?

sponsored ads

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in advance.

Asked Sep, 15 2010
add commentflag 

sponsored ads

answer this question

3 answers

Hi, you can try to use command prompt to reset your lost password. I have used it to reset sql sa password successfully on sql server 2000/2005.


First, open a command prompt (Start -> Run -> cmd)


Then, type the follow commands, and press Enter after each line:


Osql –S yourservername –E


1> EXEC sp_password NULL, 'yourpassword', 'sa'


2> GO


It could help you. And i know a sql reset tool which can easily and instantly reset your sql sa password, you can try it also. http://www.passwordunlocker.com/sql-server-password-recovery.html



Answered Sep, 15 2010
add comment|flag 
vote up 1 vote down
check

I think the easiest way to reset lost SQL sa password is to use this software: SQL Server Password Changer - http://www.top-password.com/sql-server-password-recovery.html Answered Mar, 03 2012
add comment|flag 
vote up 0 vote down

Hey, there.

Windows Password Recovery Corporation is a professional Windows server password reset software. Burning the BIOS image to the CD/DVD/USB Flash Drive and then reboot the PC with it. You can reset the password quickly.

Here is its official website, it offers step by step user guide about the how to reset server 2005 password:

http://www.windowspasswordrecovery.net/support/corporationuserguid.html

Answered Nov, 10 2010
add comment|flag 
vote up 0 vote down

# You'll need to create a bootdisk using another PC (not your locked computer). If you don't have another PC, you'll have to borrow one of your friends. Then, you'll need to download the .zip archive of Reset Windows Password Enterprise on the computer, Unzip the download file and burn the ISO image to a blank CD/DVD using any ISO burning software.
# Boot your locked PC from the bootdisk (you might have to adjust the BIOS to allow booting from the CD).
#

Just wait a while until the bootdisk launches the Reset Windows Password program.
# If you want to reset domain user account passwords, choose the Reset Active Directory Password. Otherwise choose the Reset Local Admin/User Password option to reset local user account passwords.
# Select a user account from the list, and then click Reset Password button to reset your forgotten password.
Next restart your computer and remove the bootdisk, you'll be able to login your Windows Server user account immediately without reinstall the whole operating system. Answered Jul, 23 2012
vote up 0 vote down

Once you forgot Windows 7/vista/XP password, Windows Login Recovery is a good choice to recover lost password. However, many Windows users failed to get Windows vista password reset as its large ISO file which is more than 496MB, so I share a useful software which can help you to reset windows vista password easily and effectively. This software is Windows Login Recovery.

http://www.windowsloginrecovery.com/ Answered Jun, 04 2012
vote up 0 vote down

Click on Start and choose Run.
Type in Regedit and select OK.
Now click on the little plus sign to the left of H_KEY_LOCAL_MACHINE. Navigate down, always clicking on the plus sign at the left of the named key, through Software, Microsoft, Windows, Current Version and Policies.
Now click on the Ratings folder.
In the right pane of the RegEdit window, you'll see an icon called Key. Click on it and press Delete.
Next, choose Registry and then Exit to exit Regedit. You've just deleted your original Content Advisor password.
Restart the computer and run Internet Explorer again.
Choose View and then Internet Options
Click on the Content tab and click on Disable. When asked for a password, don't enter anything; just click on OK. This will disable Content Advisor because there's no longer a password.

Answered Sep, 29 2010
vote up 2 vote down

Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
Create one

Options

sponsored ads

Download related software from AFC

SoftTree SQL Assistant 6.3.171

Last Updated: Dec 7, 2012
License: Shareware
Filesize: 11.59MB

Continue to downloadPower by Afreecodec.com