[resolved] Problem retrieve tables schemes on SQL Server 2008 R2 / Talend v5.0.2
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
Hi Pedro I found that on the web : "In MS SQL - Create a user - Create a role - Add your user to the role created - Add your user to the db_owner role - Go to the properties of your schema - Add the role that you created - Selection can be made in the matrix of the different bottom right SELECT You can now access your database schema through talend specifying the component's info (USER, PWD, SCHEMA, etc ...)" Do you think that can resolve our problem ? Did you have an answer about your own ticket in the Talend bug tracker ? Could you give me the link to follow it ? Thx
Hi
Welcome to Talend Community!
In fact, I'm facing the same issue.
I have a schema called "ABC" in SQL SERVER.
When I try to retrieve schema from ABC, it shows "Pending" and never stop.
However, if the schema is dbo, the retrieving works fine.
Please report it on
BugTracker.
Regards,
Pedro
Hi Pedro I found that on the web : "In MS SQL - Create a user - Create a role - Add your user to the role created - Add your user to the db_owner role - Go to the properties of your schema - Add the role that you created - Selection can be made in the matrix of the different bottom right SELECT You can now access your database schema through talend specifying the component's info (USER, PWD, SCHEMA, etc ...)" Do you think that can resolve our problem ? Did you have an answer about your own ticket in the Talend bug tracker ? Could you give me the link to follow it ? Thx
You can now access your database schema through talend specifying the component's info (USER, PWD, SCHEMA, etc ...)"
Yes. You can configure the MSSQL components manually to access tables from other schema. I have thought you knowed this and just wanted to report the 'pending' bug. Regards, Pedro
Now in 5.1.1 connection is totally impossible... When you check connection there is a message : "Access to the data failur{0} Connection failure. You must change the Database Settings. java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2"
