3620937 - SAP HANA SDA connection connects to the unexpected MS SQL Server database

Symptom

SAP HANA SDA remote connection is configured to connect MS SQL Server tenant database <DB1> according to SAP help portal, however, the remote connection still connects to the master database.

Indexserver confirms that master database is connected instead.

FedTrace odbcinfo.cpp(00508) : {R -1} SQL_DATA_SOURCE_NAME = <DATA_SOURCE_NAME>

FedTrace odbcinfo.cpp(00517) : {R -1} SQL_DATABASE_NAME = master

The odbc.ini is configured as below:

[<DATA_SOURCE_NAME>]

driver= <driver_path>

sql_server_name=<hostname>,<sql_port>

sql_database_name=<database_name>

Environment

SAP HANA 2.0, Microsoft SQL Server 2017

Product

SAP HANA, platform edition 2.0

Keywords

sql_database_name, odbc.ini, master database, SQL_DATA_SOURCE_NAME, , 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 for Me (Login required).

Search for additional results

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