SAP Knowledge Base Article - Preview

3071039 - HANA SDA config for MSSQL Active Direcory User

Symptom

Will HANA SDA config accept an Active Direcory (AD) user to be used as technical user?


The user provided by the MSSQL team is a windows authenticated user and not an SQL user. The below error occurs, when trying to run following command from our HANA server end:

isql -v <DB_NAME> < user> <password>

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

All libraries are already in place, the user ABCZXYG2 is an AD account.


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

smart, data, access, microsoft, , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.