Changing a Password

Perform the following steps to change a login password:

1.
From the SQL Server Enterprise Manager, click the plus (+) sign next to the server that contains the login.
2.
Click the plus (+) sign next to the Security folder.
3.
Left-click the Logins icon. A list of logins appears in the Result pane.
4.
Right-click the name in the Result pane. From the right-mouse menu, select the Properties menu option. The SQL Server Login Properties dialog box appears.
5.
Enter the new password.
6.
Click the OK button to save the password. The Confirm Password dialog box appears.
7.
In the Confirm Password dialog box, enter the password again to confirm the change.
8.
Click the OK button to save the password.

NOTE

This topic of changing ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.