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

Following error messages occur when SQL submitted to an ODBC data source in CPI-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.

• SAP Cloud Platform Integration for Data Services 1.0
• Microsoft SQL Server 20xx

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