cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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
0 Kudos

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
Explorer
0 Kudos

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