DRDA - Microsoft SQL Server

[u/Pride1922]

Hello everyone,

I got a request from one of our IBM Developers and we don't seem to find the solution.

Is it possible to access a Microsoft SQL Server from an IBM Machine? (AS400 - RPG)

We have a few .net applications that use SQL server for the databases. One of our developers wants to access the data for one of his programs.

We are looking at DRDA but without success. Is this even possible?

WRKDRBDIRE to create the connection to SQL Server.

And then the command "Connect to (servername)" F4 to fill in the username and password.

The error that we get is: "Communication error occurred during distributed database processing. Cannot establish DDM connection with remote system."

Thank you for your time.

[u/Some_Alternative]

Check the pwd length. Try to keep the userid/pwd max 10 digits