cancel
Showing results for 
Search instead for 
Did you mean: 

Question regarding SAP Smart Data Access

Former Member
0 Kudos

I am configuring SDA on HANA. Installed the SQL Drivers. Created a DSN and Remote Share.

I have 4 databases in SQL Server and the SQL login I used for Remote Share - has got DBO Access to all the 4 databases in SQL Server 2008.

But somehow, I can only see one SQL database on the SDA side. Other 3 databases are not visible on the SDA side.

I have checked everything on the SQL Side.

One thing which I am not clear is - on the SDA side, it shows Adpater as SQL 2012.

Can HANA SPS7 connect to SQL 2008 servers or not?

Any help will be useful.

Regards

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello, Ashok!

So, HANA SPS7 does really connect to MSSQL 2008, yes?

Thanx, in advance,

Oleg

Former Member
0 Kudos

I think I know the root cause of the problem.

On SQL Server side, we have to select a default Database for every SQL Login.

On the SDA, it is only showing only the default database for that SQL login. SQL Login has access to some other databases also, but those are not shown on SDA side.