UniDAC

TMSSqlUtils.ChangePassword Method

Changes the password of an account to the new password.

Class

TMSSqlUtils

Syntax

class procedure ChangePassword(Connection: TCustomDAConnection; NewPassword: string);

Parameters
Connection
NewPassword
Takes the new password.

Remarks

Call the ChangePassword method to replace an expired user's password with the new password. In SQL Server versions prior to SQL Server 2005, only the database administrator has permissions to change an expired user's password. Starting with SQL Server 2005, you can change the password using the ChangePassword method and SQL Native Client.

Note: Only an expired password can be changed using this method.

© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback