SAP Knowledge Base Article - Preview

3491362 - SDA connection to MS SQL DB fails, error message in MSSQL trace shows "Server is configured for Integrated authentication only"

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 "Server is configured for Integrated authentication only"


Read more...

Environment

SAP HANA Platform Edition

Product

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

Keywords

mssql, mixedmode, windowsauthentication , 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.