Take the following steps to configure user ID/Password authentication:

  1. Set the AuthenticationMethod property to userIdPassword.
  2. If necessary, set the KeyspaceName connection property.

    If authentication has not been enabled, client applications will have access to all keyspaces on the server. If authentication has been enabled, a client application will only have access to the keyspace specified by the KeyspaceName property assuming it has the required permissions.

    Even when authentication has not been enabled, KeyspaceName is strongly recommended because its value functions as the default qualifier for unqualified tables in SQL queries.

  3. Set the User property to provide the user ID.
  4. Set the Password property to provide the password.