Take the following steps to configure User ID/Password Authentication.

  1. Set the AuthenticationMethod connection property to one of the following valid user/id password values.
    • Option 1. clearText
    • Option 2. encryptedPassword
    • Option 3. encryptedPasswordAES
    • Option 4. encryptedUIDPassword
    • Option 5. encryptedUIDPasswordAES
    Note: If you enable AES encryption by specifying encryptedPasswordAES or encryptedUIDPasswordAES, you can configure random number generator secure seeding. If you want to configure secure seeding, complete your configuration of user id/password authentication by proceeding to Configuring Random Number Generator Secure Seeding.
    Note: The AuthenticationMethod property can also be set to either client or kerberos. However, when either of these values are specified, the driver ignores any user ID or password specified.
  2. Set the User property to provide the user ID.
  3. Set the Password property to provide the password.