SAP Knowledge Base Article - Preview

3664830 - MS SQL connection stopped working in SAP Data Intelligence - SAP Data Intelligence

Symptom

  • Did not change the MS SQL connection configuration in DI side.
  • Database name do not contain a backslash (\) or period(.) and Password do not contain a dollar sign ($)
  • MS SQL Connection stopped working all of sudden. Below error reported when checking the connection status:
    "Status code from service response: 400, Message: Failed to validate connection XXXXXXXX. 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 
  • Microsoft SQL Server (MSSQL) 
  • SAP Cloud Connector (SCC)

Product

SAP Data Intelligence Cloud all versions

Keywords

SAP Data Intelligence (DI) Cloud, DI, Microsoft SQL Server (MSSQL), MS SQL, SAP Cloud Connector (SCC), SAP JVM, sapjvm, upgrade, response: 400, Socket closed, DriverUnicodeType. , KBA , CA-DI , Data Intelligence , BC-MID-SCC , SAP Cloud Connector On-Demand/On-Premise Connectivity , 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.