Configure authenticate Mechanism in Squirrel SQL C

问题:

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 ?

回答1:

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