No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


How to change the sa password If the password Is forgotten

Publication Date:  2012-07-24 Views:  112 Downloads:  0
Issue Description
When you install the log server, you need to set up the connection between the Secospace eLog and the database to authenticate the sa password. If you forget the sa password, the connection fails and installation stops. Then you need to obtain the sa password back or reset the sa password.
Alarm Information
Handling Process
1. Choose Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
A dialog box for identity authentication is displayed. See the following figure.

2. In the Authentication drop-down list, select Windows Authentication.
3. Click Connect.
4. On the left menu bar, choose Security > Logins > sa.
See the following figure.
5. Right-click sa and choose Properties.
6. On the left tab Select page, click General.
7. In the Password text box on the right, enter a new sa password.
8. In the Confirm password text box, enter the new sa password again. Confirm password must be the same as Password.
See the following figure.

9. Click OK.
Changing the sa password is complete.
Root Cause