3407845 - Error when validating Microsoft SQL Server connection in SAP Datasphere

Error is raised during validation of Microsoft SQL Server connection created in SAP Datasphere via Space Management:

Data Flows: Cause: Open request could not be performed due to error: Socket closed.
Invalid attribute in connection string: DriverUnicodeType. Code:1103002

• SAP Datasphere

Executing "Validate" in Connections in SAP Datasphere.

Possible Cause 1: Firewall/proxy configuration issue.

Possible Cause 2: Wrong protocol used in SAP Cloud Connector.

Resolution for Cause 1:

1. If you are using egress firewalling, add the following domains (wildcard) to the firewall/proxy allowlist in your on-premise network:
   • *.hanacloud.ondemand.com
   • *.k8s-hana.ondemand.com
2. Add Datasphere outbound IP address in SAP Cloud Connector firewall allowlist.
   Administrators can find the Outbound IP Address from the side navigation area by System -> About and expanding the More section in the dialog.
   Please add this IP address in cloud connector allowlist.
3. Also, add SAP Cloud Connector public (External) IP address in SAP Datasphere allowlist. Add IP address to IP Allowlist | SAP Help Portal 
       

Resolution for Cause 2:

For Microsoft SQL Server (data flow used with the connection), please use TCP protocol. Have a look at below on-line document step 3.b for detail information. Configure Cloud Connector | SAP Help Portal

KBA , DS-DI-CON , Connections , Problem