Data Replication 2
Results 1 to 2 of 2

Thread: Cannot connect to Redshift server [122515] Authentication failed

  1. #1
    OritA is offline Junior Member
    Join Date
    May 2015
    Posts
    3
    Rep Power
    0

    Cannot connect to Redshift server [122515] Authentication failed

    When defining the Amazon Redshit Target if you get the following error (when testing that it works):

    Cannot connect to Redshift server [122515] Authentication failed
    RetCode: SQL_ERROR SqlState: 28000 NativeError: 210 Message: Communication error during authentication;
    Error while reading from the socket. [122502] ODBC general error.

    The cause of the error was wrong version of postgress driver version.
    The driver that version that caused the error was: psqlODBC_x64. Version: 09.00.0101.

    The issue was resolved by installing the latest postgress driver: psqlodbc_09_03_0300-x64-1.

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    299
    Rep Power
    6
    Also notes that with Replicate version 4.0.9xx we are default to using the Amazon Redshift Client.

    The Amazon Redshift Client can be download with link below:

    https://s3.amazonaws.com/redshift-do...1.2.1.1001.msi

    You would need to restart the Attunity Services to use the new Client after installed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •