How to reset ’sa’ password if SQL Password is lost/forgotten/unknown?

How to reset ’sa’ password if SQL Password is lost/forgotten/unknown?

First off, you can log in as any SSO role user and have them reset the ’sa’ password for you.

Being life and life being not always so simple we may not always have an SSO role handy (or configured)

So, we resort to the following:

1. Edit the ‘runserver’ file. By default it’s in the $SYBASE_HOME/install directory
2. Add “-psa” (for password ’sa’) to the end of the command line. (I have noticed that this DOES NOT work in windows unless it’s the FIRST param on the command line)

 

3. Save file and reboot server. You ‘may’ have to use Unix ‘kill’ or Windows ‘End Task’ but I suggest that as a last resort.
4. While server is restarting, watch the console. You will see something like. “New SSO Password for sa:akshentneksla”. If you miss it in the console, check the error logs. It will also be written there.
5. Re-Edit the runserver file once the server has ‘booted’ and remove the “-psa”. If you don’t, the next time the server is restarted it will RESET the sa password again and you’re screwed all over.
6. Login as ’sa’ using the new password (In this case: akshentneksla).
7. use sp_password to change the password to something you will remember.
8. (OPTIONAL) reboot server to make sure all is nice and neat. (See Note #2 below!).Some Notes:1- People have claimed that they are still not able to login with this new password. If that is the case make sure that the ’sa’ account is not locked. You can do this by setting a TRACEFLAG to “4044?. This is a boot time traceflag that allows ’sa’ to login even if his/her account is locked.

   2- Windows services do not always call the proper .bat file when they startup your service. What happens is that you may edit the ‘runserver’ .bat file and yet not have your password reset if you stop/start the service. This is because the sybase installer references the ’sqlsvr.exe’ executable with parameters DIRECTLY.  (I have not, as of this writing been able to figure out how to change this.) So, stop the service, do all the edits/steps I mention abov, but make sure you take STEP 8 and restart the server VIA THE SERVICES WINDOWS, then you will be sure that your server will start properly on subsequent executions.

Reference: http://blog.passwordunlocker.com/how-to-reset-sa-password-if-sql-password-is-lostforgottenunknown/

About the Author

ych

MLI Spring Auction 2011 Lot 5 Roger Maris Game Used Professional Model Bat PSA/DNA LOA GU 7

Halloween Bat Youth Tshirt Medium Youth (10-12) $11.99 …

The Babe Comes Home Sotheby’s Auction Catalog $25.99 An Out Of Print And Highly Collectible Sotheby’s Auction Catalog Titled “The Babe Comes Home” Sotheby’s Auction Catalog Dated December 2, 2004 Lot Size 304 198 Pages Final Auction Prices Included A Sale Of Important Baseball Memorabilia With A Particular Focus On The History Of Baseball . Highlighting The Sale Was “The Holy Grail” Of Sports Memorabilia, The Bat With Which Babe Ruth Sl…

Premier Collectibles II Auction August 10th, 2006 — High Grade Card & Collectible Auction — Babe Ruth Signed Photograph, Feel The Greatness 1963 Mickey Mantle Game Used Bat Graded a Perfect 10!, Rare Honus Wagner PSA 1912 Plows Candy 119 Page Auction Booklet of High-End Sports Collectibles–Filled with Lots of Colored Pictures and Descriptions of Sports Items…

Monster High Electrocuties Pet Count Fabulous $4.95 Ghoulishy fun pet play the Monster High way! Press the top of the pets head and his/her skeleton lights up for scary cool fun!…

Sadaharu Oh Autographed Ash Bat W/PROOF, Picture of Sadaharu Signing For Us, Team Japan, Yomiuri Giants, Japan Home Run King, PSA/DNA Authenticated This is a Sadaharu Oh signed full size Ash Rawlings Big Stick Bat. This bat was signed in a black sharpie. This item has been authenticated by PSA/DNA. This item will come with a Certificate of Authenticity (of our own design) as well as a picture of the athlete/celebrity if we have one. All of our items are obtained in person and are 100% authentic….

Jim Rice Autographed Rawlings Bat HOF PSA/DNA This is a Rawlings bat that has been hand signed by Jim Rice. He has added his “HOF 09″ inscription. It has been authenticated by PSA/DNA and comes with their sticker and matching COA….

Jason Heyward Signed Autographed Atlanta Braves Jersey Psa/dna Coa & Hologram $299.99 THIS IS A MUST HAVE JERSEY. ALL MY ITEMS COME WITH CERTIFICATE OF AUTHENTICITY, HOLOGRAM, AND PICTURES OF PLAYERS SIGNING…

Autographed Brian McCann Bat – PSA/DNA – Autographed MLB Bats $109.99 Autographed Brian McCann Bat – PSA/DNA. Unlike other online sports memorabilia retailers, all of our items have been certified authentic and come with a money back guarantee. Perfect signature quality. It can be difficult to find pieces like this since Brian McCann doesn’t paticipate in signing sessions very often. Compare McCann’s stats to anyone else and you’ll see why collectors love pieces lik…

Bat Lady $79.99 Bat Lady

Ninja Bat $24.99 Ninja Bat

Baby Bat $34.99 BABY BAT Costume includes: Jumpsuit and hood.

Bat Eyes Glasses $9.95 Bat Eyes Glasses

Bat Print Witch Hat $7.99 Bat Print Witch Hat

Little Bat Panne $29.99 Little Bat Panne

Phantom Black Bat Mask $8.99 Phantom Black Bat Mask

Flappy Bat Hat $19.99 Flappy Bat Hat

Gothic Bat Glasses $14.99 Gothic Bat Glasses

Sequin Bat Black PBH $6.99 Sequin Bat Black PBH

Pete Rose Autographed Bat / Details: Big Stick Blonde Bat, ”4256” Inscription $229.99 Pete Rose signed Rawlings Big Stick blonde bat w/4,256 inscription – his record career hit total. Item has been authenticated with an invisible DNA marking, and comes with a PSA/DNA certificate of authenticity (COA) and tamper-proof numbered hologram which can be verified online.