I want to configure a DB2 Connection in Squirrel SQL Client and my URL contains securityMechanism=13
at the end. When I am trying to connect with this URL and Test a connection in Squirrel , its throwing an error saying -
com.ibm.db2.jcc.b.SqlException: Connection authorization failure occurred. Reason: security mechanism not supported
Can anyone tell, how to handle/configure Squirrel SQL Client to make this URL working ?
I had the same problem. To solve it you need to add two properties to your SQuirreL Alias, securityMechanism=13 and encryptionAlgorithm=2. It worked in my case hope it will help for you:) Adding some Screenshots: Alias properties Driver properties