Replace the jTDS driver with Microsoft JDBC driver

  1. Right-click your environment and select Configure Application.
  2. Click Edit Properties.
  3. Search for property db.con.drivername.
  4. Click the Value link (that is, net.sourceforge.jtds.jdbc.Driver).
  5. Replace the Value with com.microsoft.sqlserver.jdbc.SQLServerDriver.
  6. Click Update Property.
  7. Search for property db.con.url.
  8. Click the "Value" link (that is, jdbc:jtds:sqlserver://<host>:<port>/<M3 BE env database name>).
  9. Replace with the Value with jdbc:sqlserver://<host>:<port>;databaseName=<M3 BE env database name>.
  10. Click Update Property.
  11. Save your changes.
  12. Restart the environment.