SAP Adaptive Server Connection Fails

Problem: SAP Adaptive Server connection details are configured correctly, but DA fails to establish a connection.

Possible cause: SAP Adaptive Server is configured to require all clients to use password encryption. If the net password encryption reqd parameter is configured to a nonzero value, login fails.

Solution: Ensure that the SAP Adaptive Server connection has the ENCRYPT_PASSWORD property set to true. Add this property to existing connections by issuing:

alter connection myAseConn 
and set ENCRYPT_PASSWORD = true
go

See Connection Properties in the SAP jConnect for JDBC 16.0 Programmers Reference.