Configure authenticate Mechanism in Squirrel SQL C

2019-08-25 04:46发布

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条回答
女痞
2楼-- · 2019-08-25 05:17

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

查看更多
登录 后发表回答