topic Re: [resolved] Connection on MS SQL Server in Talend Studio

[resolved] Connection on MS SQL Server

Anonymous — Thu, 27 Jun 2013 14:36:30 GMT

Hi to all,
I've to made some operation on a remote database (Microsoft SQL Server 2008 R2). I cannot access to the database, but I've all the information to connect to it.
Unfortunately, when I try to connect to iy, I've the following problem:
Connection failure. You must change the Database Settings.
java.sql.SQLException: Login failed for user 'xxxx'.
I cannot connect neither with Windows ODBC, cause I'm obtaining the same error.

Thank you for the help.

Re: [resolved] Connection on MS SQL Server

Anonymous — Thu, 27 Jun 2013 15:08:59 GMT

Hi,
is the database running on a remote machine? If yes, TCP/IP network protocol has to be enabled (default is disabled!). That may be a cause.
Otherwise check again the access data, maybe user or password is wrong spelled....

Re: [resolved] Connection on MS SQL Server

Anonymous — Thu, 27 Jun 2013 15:13:01 GMT

Thank you.
The TCP IP to activate, you mean on my machine on or the server?
User and password are right.

Re: [resolved] Connection on MS SQL Server

Anonymous — Fri, 28 Jun 2013 08:03:01 GMT

Hi,
What's the product build version are you using? I have make a testing on talend open studio for Data Integration 5.3.0 r101800, everything is fine.
Could you please give us the screenshot of your DB connection setting? Hide the sensitive info
See my screenshot
Best regards
Sabrina

Re: [resolved] Connection on MS SQL Server

Anonymous — Fri, 28 Jun 2013 14:56:52 GMT

Hi,
my versione is: 5.2.2.r99271
I've tried also in the last versione, but without success.
Here's the screen: http://s23.postimg.org/t7y60dh8b/image.jpg
Thank you.

Re: [resolved] Connection on MS SQL Server

Anonymous — Fri, 28 Jun 2013 15:19:21 GMT

Hi anthony,
the tcp network protocol has to be activated on serverside using the sql server configuration manager.
Maybe you also need to define a schema, commonly "dbo".
Regards,
M

Re: [resolved] Connection on MS SQL Server

Anonymous — Fri, 28 Jun 2013 15:38:33 GMT

Thank you,
using the schema doesn't solve the problem.
I've to try to contact the server administrator to check the TCP/IP connection feature.
This is the problem? Or There's something I can check on TOS?

Re: [resolved] Connection on MS SQL Server

Anonymous — Mon, 01 Jul 2013 04:30:57 GMT

Hi,
I suspect your jtds.jar doesn't work. Could you use sqljdbc4.jar (using jdbc:sqlserver)from Microsoft to take a test see if this issue rero again?
In addition, if you use talend enterprise subscription version, it suggested that you should report a ticket on support portal, our colleagues from support team will make a investigation for your issue.
Best regards
Sabrina

Re: [resolved] Connection on MS SQL Server

Anonymous — Mon, 01 Jul 2013 10:22:03 GMT

Thank you for support,
If i'll find a solution, I tell you.

Re: [resolved] Connection on MS SQL Server

Anonymous — Mon, 01 Jul 2013 10:26:55 GMT

Hi,
Thanks for your feedback.
You'd better check it on talend open studio product (The latest one is 5.3.1) to see if this issue repro. Wait for your update...
Best regards
Sabrina

Re: [resolved] Connection on MS SQL Server

Anonymous — Mon, 01 Jul 2013 11:39:47 GMT

Hi,
SOLVED. Was just wrong password...
The server admin has passed me wrong password... WTF!
Thank you.

Re: [resolved] Connection on MS SQL Server

Anonymous — Tue, 02 Jul 2013 02:44:03 GMT

Hi,
OK, thanks for your feedback. Feel free post your issue on forum.
Best regards
Sabrina