I am sure there is a post with this topic but I am struggling to find it. I also expect this is a permissions issues but my IT team is not yet able to diagnosis the issue so I am posting here.
I have a connection to a sql server environment called sqlservice_a. Inside sqlservice_a there are two databases abcd and zyxw. I was able to connect just fine to database abcd and can retrieve all the expected schemas/tables. I can connect to the zyxw database, but can not retrieve any tables, I do see the schema I want (dbo). If I login to MS Sql Server Mgmt Studio using the same account I have no issues querying the dbo tables in the zyxw database. I am unsure why Talend can not connect and query using the same account. Like I said I expect that my DBA didn't set something up correctly, but would like to point them in the right direction if someone else has encountered this.
