Take the following steps to configure user ID/Password authentication:
1. Set the AuthenticationMethod property to userIdPassword.
2. Set the DatabaseName connection property.
3. Set the ServerName connection property.
4. Set the User property to provide the user ID.
5. Set the Password property to provide the password.
6. Optionally, if impersonation is enabled on the server, set ImpersonateUser property to provide your UserID used for impersonation.
7. Optionally, if the driver is configured to use HTTP mode (TransportMode=http), set the CookieName property to provide the name of the cookie used for authenticating HTTP requests. The default is hive.server2.auth.
