Take the following steps to configure user ID/Password authentication:
1. Set the AuthenticationMethod property to userIdPassword.
2. If necessary, set the DatabaseName connection property.
If authentication has not been enabled, client applications will have access to all databases on the server. If authentication has been enabled, a client application will only have access to the database specified by the DatabaseName property assuming it has the required permissions. However, an application with clusterAdmin privileges will have access to all databases on the server even when authentication is enabled.
Even when authentication has not been enabled, DatabaseName 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.
