Computer Dekstop & Laptop Reviews

First, you can log on as a user role of the SSO and to provide â € ™ € ™ Saa password.

Such is life and life is not always so simple it does not always have a useful role SSO (or set)

Therefore, we use the following:

1. Change the â € ~ runserver € ™ file. By default Itâ € SYBASE_HOME ™ s in $ / installation directory
2. Add € â € œ-psaa (for Password Saa € ™ â € ™) at the end of the command line. (I noticed that they have not, not in Windows, unless Câ € ™ is the first parameter in the command line)
3. Save the file and restart the server. You â € ~ Maya € ™ must use Unix â € ~ killa € ™ or â € ~ Windows End Taska € ™ but I suggest that as a last resort.
4. While the server is restarted, see the console. You will see something similar. â € œNew SSO password for sa Password: akshentnekslaâ €. If you forget the console, check the error logs. Also will be written there.
5. Runserver Re-edit the file once the server has booted € ~ â € ™ and â € œ remove-€ SPAA. If nâ € ™ t together after restarting the server, it resets the SA password again and youâ € ™ re fucking everywhere.
6. Login to Saa € ™ € ™ using the new password (in this case: akshentneksla).
7. sp_password use to change the password to something you remember.
8. (OPTIONAL) reboot the server to make sure everything is nice and treatment. (See Note # 2 below!). Some comments: 1 – People have said that are not yet able to connect with the new password. If such is the case, make sure the Saa € ™ â € ™ has not is blocked. You can do this by establishing a one œ4044 € TRACEFLAG?. This is a time to start allowing traceflag Saa € ™ â € ™ to connect even if the account is locked.

   2 – Windows services are not always draw the correct file. Bat when they begin their service. What happens is that you edit May â € ~ runserver € ™ file. BAT and have not yet changed the password if you stop / start service. This is because the installation instructions Sybase sqlsvr.exeâ € ™ â € ™ DIRECTLY. executable with parameters a (not I enjoyed writing these lines have found a way to change that.) So, stop the service, change the new measures Abov mention, but make sure taking the step 8 and restart the server through Windows services, then you can be sure that your server will start correctly on subsequent executions.

About the Author:

interesting in ms sql

Article Source: ArticlesBase.com – How to reset ’sa’ password if SQL Password is lost/forgotten/unknown?