jdbc auth failing to sql from sap's cloud middleware CPI

  • hi , our business partner is asking s4 sap api's for receivable info and asking the jdbc adapter in sap's cloud middle ware to send a delete and insert to our sql staging table.   his pc is not on our network.

    our staging table sits on a 2022 std edition vm instance of sql server.

    he uses a tunnel.   we've confirmed the windows creds he passes are set up properly in the OS and sql.   he continually gets failed logins.  he appends our domain name on everything.    i told him our vm / os is notorious for requiring encryption.  i asked if he is encrypting.   his response was "only if its pgp encrypted".    i dont know what that means.

    does the community have any advice?

  • this is one of the earlier errors.

    ryanerror

  • when he changed to tcp ssl from tcp on the tunnel , he got this.   he is actually targeting port 1433.

    ryanserror2

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply