2141242 - Error "Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-*' : file not found" when using Smart Data Access

• The following error appears when trying to access the Microsoft SQL Server remote data source:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: 
[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0' : file not found
OR
[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found

• indexserver trace file:

[302687]{800131}[36/6344248368] 2023-01-06 09:04:23.079830 e FedTrace odbccustom.cpp(00709) : Configuration file:/usr/sap/ABC/HDB00/exe//config/property_mss.ini could not be opened. 
[302687]{800131}[66/-1] 2023-01-06 09:04:23.081239 e FedTrace odbcaccess.cpp(03944) : {R -1}ODBC error: connected: 0 state: 01000 code: 0 [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
[302687]{800131}[66/-1] 2023-01-06 09:04:23.081435 e FedTrace odbcaccess.cpp(03944) : {R -1}ODBC error: connected: 0 state: 01000 code: 0 [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
[302687]{800131}[36/6344248368] 2023-01-06 09:04:23.081830 e ceExecute cePopQo.cpp(00313) : Caught ptime::PtimeException: internal error: Remote Source [MSSQLSERVER] is not accessible to perform the operation: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found
; schema='SAPABAP1'; user='SAPABAP1'
Exception details: exception 1: no.71000403 (federation/api/impl/RemoteSourceFacadeImpl.hpp:90) TID: 302687
 Remote Source [MSSQLSERVER] is not accessible to perform the operation: [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.0.so.1.0' : file not found

Images/data in this KBA are from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP HANA Platform Edition 1.0
• SAP HANA Platform Edition 2.0
• Microsoft SQL Server

Smart Data Access, SDA, MS SQL Server 2012, Can't open lib, libodbcinst.so, libodbcnst.so.1, Cannot get remote source objects, not accessible to perform the operation , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem