The ENCRYPT_PASSWORD connection property specifies whether the password is transmitted in encrypted format. This same property is used to enable asymmetric key encryption. When password encryption is enabled and the server supports asymmetric key encryption, this format is used instead of the symmetric key encryption.
Set the ENCRYPT_PASSWORD connection property to true to enable password encryption. The default value is false.
If the server is configured to require clients to use
an encrypted password, entering a plain text password causes user login
to fail.
