HANA remote source for SQL Server only shows Master database

[Former Member]

Hi

I have create a couple of remote sources in HANA Studio, both SQL Server, and provided the credentials of a SQL user that has access to many databases on each server.

However, when I drill down into the remote source to add some virtual tables, the only database that displays is Master. When I use the same credentials in SQL Server Management Studio I can see all the databases.

How do I make the other databases visible? The SQL user definitely has access

[Former Member · Accepted solution]

Discovered that I can access a specfic database if I specify the DATABASE property in the DSN file, however I was hoping that I could access multiple databases through a remote source.