Login.ChangePassword Method (String, Boolean, Boolean)

Changes the password for the login account.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub ChangePassword ( _
    newPassword As String, _
    unlock As Boolean, _
    mustChange As Boolean _
)

public void ChangePassword (
    string newPassword,
    bool unlock,
    bool mustChange
)

public:
void ChangePassword (
    String^ newPassword, 
    bool unlock, 
    bool mustChange
)

public void ChangePassword (
    String newPassword, 
    boolean unlock, 
    boolean mustChange
)

public function ChangePassword (
    newPassword : String, 
    unlock : boolean, 
    mustChange : boolean
)

Parameters

• newPassword
  A String value that specifies the new password.

• unlock
  A Boolean value that specifies whether to unlock the login account's access to the instance of Microsoft SQL Server.

  If True, the login account is given access to the instance of SQL Server.

  If False, the login account remains locked out of the instance of SQL Server.

• mustChange
  A Boolean value that specifies whether the login account must change the password.

  If True, the password must be changed again.

  If False, the password will not need to be changed.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Enumerate Logins and Associated Users in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Login Class
Login Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Managing Users, Roles, and Logins
Principals
CREATE LOGIN (Transact-SQL)