SAP Knowledge Base Article - Preview

3491386 - SDA connection to MS SQL DB fails, error message in MSSQL trace shows "Could not find a login matching the name provided"

Symptom

When configuring an SAP HANA Smart Data Access to a remote MS SQL database.

The connection fails and in the HANA traces you only see "FederationRdes.cpp(00480) : access is not connected <remote source name>"

When you check the MSSQL trace from the time of the connection error, you find the entry "

Login failed for user '<sda user>'. Reason: Could not find a login matching the name provided."


Read more...

Environment

SAP HANA Platform Edition

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

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.