在DB2的Squirrel SQL Client中配置身份验证机制 [英] Configure authenticate Mechanism in Squirrel SQL Client for DB2

问题描述

我想在Squirrel SQL Client中配置DB2 Connection，我的URL包含最终的$ code> securityMechanism = 13 。当我尝试连接到这个URL并测试一个连接在松鼠，它抛出一个错误说 -

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

任何人都可以告诉，如何处理/配置Squirrel SQL Client URL工作？

Can anyone tell, how to handle/configure Squirrel SQL Client to make this URL working ?

推荐答案

我有同样的问题。要解决它，您需要添加两个属性到您的SQuirreL别名，securityMechanism = 13和encryptionAlgorithm = 2。它在我的情况下工作希望它会帮助你:)
添加一些屏幕截图：
别名属性
驱动程序属性

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

这篇关于在DB2的Squirrel SQL Client中配置身份验证机制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！