Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists.

Question
Scott Roth · Jan 10, 2020

Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists.

I am working on a BPL to take data from a MS SQL database and create an HL7 Materials Message for our EMR.  I have done this plenty of times in the past however I am running into an error.

"Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists."

What is confusing is that this BPL doesn't differ from any of my other BPLs in connecting to MS SQL Server. I know I am missing something..

This BPL will execute the 1st Stored Procedure without any issues, the issue is when it comes to executing the second stored procedure.

 

 

 

Any help would be appreciated.

#Business Operation #Business Process (BPL) #Callout #ObjectScript #SQL #Ensemble

Source URL:https://community.intersystems.com/post/remote-gateway-error-jdbc-gateway-sp-execute0-error-0-access-remote-server-denied-because-no