Symptom
- You want to connect an on-premise MSSQL database from SAP DI Cloud through SAP CC
- MSSQL and SAP CC are installed on same host
- Back-end MSSQL system has been correctly configured in SAP CC, meaning the system is reachable: https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/ca509b7635484070a655738be408da63/3cec4528a1d44efcb7be1adbf0f2286e.html
- SAP Business Technology Platform environment is able to connect to SAP CC
- SAP CC is routing connections to back-end
- However, below error is returned when testing the connection from DI Connection Management application:
Status code from service response:400, Message: Failed to validate connection.
Code: 1103002
Message: Open request could not be performed due to error: Socket closed. Invalid attribute in connection string: DriverUnicodeType
Read more...
Environment
- SAP Data Intelligence (DI) Cloud 2221.20.25
- Microsoft SQL Server (MSSQL) 2016 Express Edition
- SAP Cloud Connector (CC) 2.14.1
Product
SAP Data Intelligence all versions
Keywords
KBA , CA-DI , Data Intelligence , CA-DI-CP-PE , Pipeline Engine , CA-DI-CP , Core Platform , CA-DI-CP-PE-SCH , Pipeline Engine - Scheduling , CA-DI-CP-SEC , Security Infrastructure , 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.
SAP Knowledge Base Article - Preview