Sql Server table retrieval issue

AdamS632 — Fri, 15 Nov 2024 23:04:22 GMT

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

Re: Sql Server table retrieval issue

Anonymous — Wed, 30 Mar 2022 00:35:32 GMT

Are you able to read table from zyxw database with tMSSQLInput component?

topic Re: Sql Server table retrieval issue in Talend Studio

Sql Server table retrieval issue

Re: Sql Server table retrieval issue