Modifying Logins

After a login has been created, it may be necessary to change the password, default database, or default language. For example, a user may forget his or her password or want to change the password for security reasons, need to use a different database on a regular basis, or need to see messages in a different language.

Note If a user forgets a password, a member of the sysadmin fixed server role can change the password without knowing the original password. A user cannot change a password if he or she has forgotten it.

To change the password of a SQL Server login

To change the default database of a login

To change the default language of a login