To enable password encryption, set the EncryptPassword connection property, which specifies whether the password is transmitted in encrypted format.
When password encryption is enabled, the password is sent over the wire only after a login is negotiated; the password is first encrypted and then sent.
0 – (default) use plain text password.
1 – use encrypted password. If encryption is not supported, return an error message.
2 – use encrypted password. If encryption is not supported, use plain text password.