Changing Passwords for SQL Server Logins 

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.

When you change the password for sa, 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.