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

  1. Set the AuthenticationMethod property to userIdPassword or auto.
  2. Set the User property to provide the user ID.
  3. Set the Password property to provide the password.
  4. Specify values for minimum required properties for establishing a connection.
    1. Set the ServerName property to specify either the IP address in IPv4 or IPv6 format, or the server name for your Azure server.
    2. Set the PortNumber property to specify the TCP port of the primary database server that is listening for connections to the database.
For example, the following is a connection string with only the required properties for making a connection using user ID/password authentication.
Connection conn = DriverManager.getConnection 
          ("jdbc:datadirect:sqlserver://server1:1433;
          AuthenticationMethod=userIdPassword;User=test;
          Password=secret);