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
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'
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
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.htmlAnswered Nov, 10 2010
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
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.
Search for Related Topics
build lost kms server retrieving image sql server display datagridview c# soyal server reset resetting inty exo server toad sql server reset evaluation retrieve restore images sql server c# datatable unistall pl sql dev reinstalling sql server 2012 express trial period reset reset regecafepro server reset evalution period sql server reset sql server 2012 evaluation adviced ccboot server hardisk
Related Unresolved Questions
3 architetto esterni giardini interni 7 anytime gezginler indir upgrade windows download fix rundll32.exe software flash flashplayer.xpt latest npswf32.dll portable aacs decodificador descargar el librer para as3 twitpic upload 7 alienware download mouse pointers windows