Hello
This is my first post here so sorry if I'm not using best practices.
This is my problem:
I have a SQL Server 2008 R2 hosted on a Windows Server 2003 64 bit.
On this database I created two schemes and dedicated users/connections owners of these schemes in SQL Server authentication.
I attack these schemes since Talend V5.0.2 deployed on a desktop Windows XP 32-bit.
No problem to create connections "MS SQL Server" (jtds).
But when I try to retrieve schemes of my tables, Talend tell me "waiting" indefinitely.
I tried everything in terms of rights on my users (sysadmin, dbowner etc.) but nothing changes.
It happens the same thing if I use the "sa" user.
In fact, what I do, the only schemes I can retrieve my tables schemes are dbo and sys. I can not retrieve the tables schemes from other database schemes.
Odbc connection is worst, I can not recover tables schemes at all.
Does anyone here have a solution and / or the same problem?
Thank you for your answers, and please come back to me if you need additional information.
Rergards