Smart Data Access to SQL Server DB(tables not visible)

[Former Member]

Hi,

I am connecting to SQL Server database through HANA's Smart Data Access(SDA). When I connect, I am able to see the schema names but tables within these schemas are not visible. Can someone guide me on this?

[Former Member]

Hi Niranjan,

Can you check if the authorizations assigned for the user on the SQL Server is working?

You can test by logging into the SQL Server management studio with the user and password and check if you can access the tables?

Also share the SQL Server version for this SDA configuration

Sunil

[Former Member]

Hi Sunil,

The tables are present and I am able to see them in SQL Server Management Studio and toad. We are currently on SQL Server v12.0.4100 (2014)

[JamesRedman]

I am getting this error too but am connecting to a SQL Database on Azure. Any thoughts?