3661257 - Error when validating Microsoft SQL Server connection in SAP Datasphere: "Open request could not be performed due to an error returned by DS-Lite (MDS)"

Symptom

When validating Microsoft SQL Server connection in SAP Datasphere, the following error occurs:

---------------------------------------------------------------------------------------
Connection XXXX couldn’t be established.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.

Data Flows: Cause: Open request could not be performed due to an error returned by DS-Lite (MDS): "Socket closed.
Invalid attribute in connection string: DriverUnicodeType."

Replication Flows: Cause: Open request could not be performed due to an error returned by DS-Lite (MDS): "Socket closed.
Invalid attribute in connection string: DriverUnicodeType."

---------------------------------------------------------------------------------------

Environment

SAP Datasphere

Product

SAP Datasphere all versions

Keywords

connection error, DS-Lite (MDS), socket closed, invalid attribute, DriverUnicodeType, SQL Server, SAP Datasphere, Cloud Connector, replication flows, data flows , KBA , DS-DI-CON , Connections , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.