Is the DSN a machine/system DSN or a User DSN? That might make a difference.
Also, if using Kerberos or IWA, there might be a Trusted for Delegation change needed. With the RSUBMIT, you're introducing an addition network hop between the client(s) and the target database.
Moving this topic to Data Management for more experts to see it.
Become an Explorer! Join SAS Analytics Explorers to learn and complete challenges that earn rewards!