Connection issue to DB2 from synapse linked service

Question

Hello All,

I want to import data from DB2-on premises using azure synapse.

Getting error while creating linked services using self hosted IR.

Answer 1

Hi @Ansari, Javed

Thanks for the question and using MS Q&A platform.

Apologies for the inconvenience that you are facing here.

The error message “Have not received expected codepoint: EUSRIDNWPWD, SQLSTATE=HY000 SQLCODE=-1040” typically indicates a problem with the authentication process.

Could you please re-check credentials and authentication:

• Ensure the username and password you're using in Azure Synapse Analytics are accurate for your DB2 server. Pay attention to typos and case sensitivity.
• Verify the chosen authentication method in Azure Synapse Analytics matches the one configured on your DB2 server.

Please consider the following prerequisites when using the Copy Activity in Azure Data Factory and Synapse Analytics pipelines to transfer data from a DB2 database. For additional information, please refer: Prerequisites.

The error code 22708 in Azure Synapse Analytics typically signifies a mismatch between the specified database scoped credential name and the landing zone URL path. Please refer the Errors and events documentation for more details.

For more details, please refer to the related discussion thread which might help you in getting some useful insights: https://learn.microsoft.com/en-us/answers/questions/1281170/adf-connecting-to-ibm-db2-cloud

I hope this information helps. If the issue still persists, please do let us know. Glad to help.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.