I wan to get back sa password 1

[babeo]

Hi,

I forget the sa password, now I want to log in as 'sa', how can I do it?
Thanks

 

[JeanNiBee]

Hey

If you log in as anyone with the SSO role you can have them change the sa password.



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[babeo]

Thanks,

If I don't have the SSO role nor known anyone that has,then what can I do then?

 

[JeanNiBee]

Did a little searching.

If you don't have a login with SSO you can do this.
[OL]
[LI]Edit the 'runserver' file. By default it's in the $SYBASE_HOME/install directory
[LI]Add "-psa" (for password 'sa') to the end of the command line.
[LI]Save file and reboot server. You 'may' have to use unix Kill but I suggest that as a last resort.
[LI]While server is restarting, watch the console. You will see something like. "New SSO Password for sa:akshentneksla"
[LI]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.
[LI]Login as 'sa' using the new password (In this case: akshentneksla).
[LI]use sp_password to change the password to something you will remember.
[LI](OPTIONAL) reboot server to make sure all is nice and neat.
[/OL]

Now as a note, 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.

Hope this helps.

(I'll be making this topic an FAQ, please everyone comment/adjut and help me out with it)

Thanks.



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[babeo]

Thanks alot JeanNiBee

 

[sybaseguru]

All look good,
Under point 4, the sybase generated "sa" password is written to the errorlog of sybase so in case you miss it do not worry, do a search in errorlog

 

[JeanNiBee]

Thanks...

I added this point to the FAQ.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[sybaseguru]

Good FAQ, I am sure many will find it useful

 

[JeanNiBee]

Thank you.

-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects