SAP Knowledge Base Article - Preview

2772294 - "SQL submitted to ODBC data source <> resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]" error occurs when SQL submitted to ODBC data source - SAP Cloud Platform Integration for Data Services

Symptom

Following error messages occur when SQL submitted to an ODBC data source in CI-DS:

  • Data flow <data flow name>|Reader <reader name>
    SQL submitted to ODBC data source <data source name> resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]The
    server principal "<user name>" is not able to access the database "<database name>" under the current security context.>. The
    SQL submitted is <SQL statement>.

  • Data flow <data flow name>|Reader <reader name>
    SQL submitted to ODBC data source <data source name> resulted in error <*****>. The SQL submitted is <*****>. This message contains
    some internal system details which have been hidden for security. If you need to see the full contents of the original message,
    ask your administrator to assign additional privileges to your account.


resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]" error occurs when SQL submitted to ODBC data source - SAP Cloud Platform Integration for Data Services"> Read more...

Environment

  • SAP Cloud Integration for data services
  • Microsoft SQL Server 20xx

Product

SAP Cloud Integration for data services all versions

Keywords

LOD-HCI-DS, HCI, CPI-DS, Microsoft SQL Server, ODBC, SQL, submit, data source, error, server principal, security, administrator , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , 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.