3280758 - Enabling SNC between CPI-DS and ABAP backend fails with "Test failed for the default configuration 'default'"

Enabling SNC between CPI-DS (SAP Cloud Platform Integration for Data Services) and ABAP on Premise backend fails with different errors like:

• specified in the datastore type is invalid. Make sure that the directory is configured from the Data Services agent and verify that the paths and permissions are correct." data-sap-ui="__alert5--msg" id="__alert5--msg">Test failed for the default configuration 'default' of datastore: '<Data Store name>':
  The directory </users/<sid>adm/DataServicesAgent/linuxx86_64/> specified in the datastore type is invalid. Make sure that the directory is configured from the Data Services agent and verify that the paths and permissions are correct.

• Test failed for the default configuration 'default' of datastore: '<Datat Store name>':
  Cannot connect to SAP Applications datastore <> using host </H/<IP>/S/3289/H/<IP>>, client <100>, user <>, and system number <10: CRFC error: RFC_COMMUNICATION_FAILURE-
  LOCATION CPIC (TCP/IP) with Unicode
  ERROR GSS-API(maj): Miscellaneous failure
  GSS-API(min): A2200223:Peer certificate path not trusted
  target="p:CN=<your.organization.com, OU=<your organizational unit>,
  OU=<your organizational unit>, L=<Locality>, C=<CountryName>"
  TIME Fri Aug 5 17:45:36 2022
  RELEASE 753
  COMPONENT SNC (Secure Network Communication)
  VERSION 6
  RC -4
  MODULE /bas/753_REL/src/krn/snc/sncxxall.c
  LINE 3604
  DETAIL SncPEstablishCon[SAP Partner]>. Please make sure the SAP server is running and the login information is correct.

• using host <IP>, client <100>, user <>, and system number <10: CRFC error: RFC_LOGON_FAILURE- Name or password is incorrect (repeat logon)[SAP Partner]>. Please make sure the SAP server is running and the login information is correct." data-sap-ui="__alert3--msg" id="__alert3--msg">Test failed for the default configuration 'default' of datastore: '<Data Store name>':
  

  ThEppImplicitCreationAllowed: reject implicit EPP creation for <user name>
  N GetUsraclSnc: found matching user ><Technical user name for SNC>< in client 100
  M ThEppImplicitCreationAllowed: reject implicit EPP creation for <user name>
  N GetUsraclSnc: found matching user ><usaer name>< in client 100
  N GetUsraclSnc: multiple matching entries found in USRACL
  M ThSavUsrClient: set client >000<

• S/4 HANA on Premise
• SCM_IBP_INT_S4
• DS AGENT_VERSION=1.0.11.x
• DS AGENT_ENGINE_VERSION=14.2.x

KBA , BC-MID-RFC , RFC , LOD-HCI-DS , HANA Cloud Integration for Data Services , BC-SEC-SNC , Secure Network Communications , BC-IAM-SSO-SL , Secure Login , Problem