Share via


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 _
)
'Usage
Dim instance As Login 
Dim newPassword As String 
Dim unlock As Boolean 
Dim mustChange As Boolean

instance.ChangePassword(newPassword, _
    unlock, mustChange)
public void ChangePassword(
    string newPassword,
    bool unlock,
    bool mustChange
)
public:
void ChangePassword(
    String^ newPassword, 
    bool unlock, 
    bool mustChange
)
member ChangePassword : 
        newPassword:string * 
        unlock:bool * 
        mustChange:bool -> unit
public function ChangePassword(
    newPassword : String, 
    unlock : boolean, 
    mustChange : boolean
)

Parameters

  • unlock
    Type: System.Boolean
    A Boolean value that specifies whether to unlock the login account's access to the instance of 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
    Type: System.Boolean
    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.

Examples

Managing Users, Roles, and Logins

See Also

Reference

Login Class

ChangePassword Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)

CREATE LOGIN (Transact-SQL)