PostgreSQL Test Connection - Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10

Problem

Sometimes you might get the following error while trying to connect PostgreSQL using the ZS PostgreSQL Connection Manager in PostgreSQL Source or PostgreSQL Destination or PostgreSQL ExecuteSQL Task. 

Test Failed: Connection failed. You are using older library which doesn't support new authentication type (e.g. SCRAM-SHA-256 Hash).
Possible work around is upgrade current library with minimum .net 4.5 Framework or higher. 
Contact ZappySys support if suggested work around doesn't help. 
Error: Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10
Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 10

Possible Cause

In most cases, it happens due to you having older version of SQL Server like 2012 or older version as Target Version in the SSIS Project.

Possible Solutions

So as a solution, you need to change the Target SQL Server version to 2014 or HIGHER Version as TargetServerVersion.

Right click on Projects >> Go to Properties >> Configuration Properties >> TargetServerVersion >> Select SQL Server 2012 or higher version.

Contact Us

if you have more questions feel free to contact us via Live chat or email at [e-mail]

https://zappysys.com/support/