Show TOC

Changing Passwords for SQL Server LoginsLocate this document in the navigation structure

This section shows how to change the passwords for SQL Server Logins

Procedure
  1. In the SQL Server Management Studio, open the Object Explorer.
  2. Expand the server and Security.
  3. Expand Logins.

    On the left you get a branch of logins defined for the server.

  4. Right-click the login for which you want to change the password and choose Properties.
  5. The Login Properties dialog box opens.
  6. On the General tab, enter a new password for the login you have selected, and confirm your password with OK.

    The new password is now valid.

    Tip

    When you change the password forsa, you have to specify the master database as the default database for the login.

For more information on SQL Server users and logins in the SAP environment, see SAP Note 592514.