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>

Reminder

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

upgrade

How to change the sa password If the password Is forgotten

Publication Date:  2012-07-24 Views:  46 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
None
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
None
Suggestions
None

END