Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks
Are you able to read table from zyxw database with tMSSQLInput component?