SAP Knowledge Base Article - Preview

2190798 - SDA connection error: SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired

Symptom

An SDA connection is setup to MSSQL server but failing with this Error:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired

SAMPLE:

Remote source kba.PNG

When you try to test this configuration you see the below error:

Remote source kba 1.PNG

Performing an ISQL connection test (isql -v DSN -u user -p password) is also failing:

[S1T00][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired
[08001][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x102
[08001][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
[ISQL]ERROR: Could not SQLConnect


Read more...

Environment

  • SAP HANA platform edition
  • SDA (Smart Data Access)
  • Microsoft SQL Server (MSSQL)

Product

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

Keywords

unixODBC, Microsoft, ODBC Driver 11 for SQL Server, Login Timeout expired, Cannot get remote source, objects

, 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.