I can connect to SQL Server with native or jdbc driver and it lets me explore object in that one database, but for an instance that has many databases, it would be nice to see explore those objects too.
In the data source definition if I leave the database field blank, it connects me to master. If I fill the field with a db name, it connects me to that one db only. I can't see any other database objects.
Is this intended or is something wrong ?