The connection between MS SQL Server and SAP HANA database through linked servers fails with the following error:
Msg 7411, Level 16, State 1, Line 1
Server 'HANAREMOTE' is not configured for DATA ACCESS.
- SAP HANA database;
- MS SQL Server;
sql 7411, Msg 7411, Level 16, State 1, Line 1, Server is not configured for DATA ACCESS, linked server, link server, data source, odbc, connection, microsoft, sqlserver, sqlservr, studio, SSMS, query , KBA , HAN-DB , SAP HANA Database , Problem
About this pageThis 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.