| First off, you can log in as any SSO role user and | | | | case: akshentneksla). |
| have them reset the ’sa’ password for you. | | | | 7. use sp_password to change the password to |
| Being life and life being not always so simple we may | | | | something you will remember. |
| not always have an SSO role handy (or configured) | | | | 8. (OPTIONAL) reboot server to make sure all is nice |
| So, we resort to the following: | | | | and neat. (See Note #2 below!).Some Notes:1- People |
| 1. Edit the ‘runserver’ file. By default it’s in the | | | | have claimed that they are still not able to login with |
| $SYBASE_HOME/install directory | | | | this new password. If that is the case make sure that |
| 2. Add “-psa” (for password ’sa’) to the | | | | the ’sa’ account is not locked. You can do this |
| end of the command line. (I have noticed that this | | | | by setting a TRACEFLAG to “4044?. This is a |
| DOES NOT work in windows unless it’s the FIRST | | | | boot time traceflag that allows ’sa’ to login even |
| param on the command line) | | | | if his/her account is locked. |
| | | | 2- Windows services do not always call the proper |
| 3. Save file and reboot server. You ‘may’ have | | | | .bat file when they startup your service. What happens |
| to use Unix ‘kill’ or Windows ‘End Task’ | | | | is that you may edit the ‘runserver’ .bat file and |
| but I suggest that as a last resort. | | | | yet not have your password reset if you stop/start |
| 4. While server is restarting, watch the console. You | | | | the service. This is because the sybase installer |
| will see something like. “New SSO Password for | | | | references the ’sqlsvr.exe’ executable with |
| sa:akshentneksla”. If you miss it in the console, | | | | parameters DIRECTLY. (I have not, as of this |
| check the error logs. It will also be written there. | | | | writing been able to figure out how to change this.) So, |
| 5. Re-Edit the runserver file once the server has | | | | stop the service, do all the edits/steps I mention abov, |
| ‘booted’ and remove the “-psa”. If you | | | | but make sure you take STEP 8 and restart the |
| don’t, the next time the server is restarted it will | | | | server VIA THE SERVICES WINDOWS, then you will |
| RESET the sa password again and you’re | | | | be sure that your server will start properly on |
| screwed all over. | | | | subsequent executions. |
| 6. Login as ’sa’ using the new password (In this | | | | |