SAP Knowledge Base Article - Preview

3071039 - HANA SDA config for MSSQL Active Direcory User

Symptom

Can HANA authenticate to MSSQL via SDA using an Active Direcory (AD) user?

isql -v <DB_NAME> < user> <password> is failing with:

[28000][unixODBC][Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user 'ADuser'.
[ISQL]ERROR: Could not SQLConnect


Read more...

Environment

  • SAP HANA DB 2.0
  • SDA (Smart Data Access)
  • Microsoft SQL (MSSQL)

Product

SAP HANA, platform edition 2.0

Keywords

smart, data, access, microsoft, sda, mssql , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , How To

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.