Configure authenticate Mechanism in Squirrel SQL Client for DB2

0
votes

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
sql-serverdb2squirrel-sql
Seems like there is an authorization problem, username correct? password correct? authentication mechanism correct? Try a direct authentication with the db2 driver: java com.ibm.db2.jcc.DB2Jcc -url jdbc:db2://localhost:50000/sample -user db2inst1 -password mypass - AngocA
My url pattern is like jdbc:db2://localhost:50000/sample:authenticateMechanism=13 and username and password is correct.if i remove authenticateMechanism=13 frm url then it throws above expection and if i add it then it will throw Invalid Url Exception. - Nir
is there a colon or semi colon before the authenticateMechanim parameter? - AngocA
Also, I do not see the authenticateMechanism as a valid parameter, but securityMechanism: www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/… - AngocA
Yup its a securityMechanism=13, and its separated with colon. Edited my post - Nir

1 Answers

0
votes

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