Share via

Failed connection from AS400 in Synapse

LIN YITONG 1 Reputation point
2022-02-21T08:36:44.91+00:00

Hi

When I try to connect to AS400 database to extract data into Synapse, I face this error.
But I can connect to the database successfully in Dbeaver. Any one know reasons?Thanks
176325-capture.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,927 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2022-02-22T14:05:17.663+00:00

    Hi @LIN YITONG ,

    Thank you for posting query in Microsoft Q&A Platform.

    As per my understanding, you are getting above error in linked service when trying to connect to DB2 server. Correct me if my understand is wrong with more details.

    Usually this kind error will indicate that the server cannot authenticate the user with credentials presented at the connection time.

    Verify connection information to ensure the User Name, Password and Security Method specified match the server requirements defined for the current user, and then re-attempt the connection request.

    If you are reading credentials from key vault then kindly try typing credentials manually to and see how it behaves.

    Hope this helps. Please let us know how it goes.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.