[resolved] Connection on MS SQL Server

[Anonymous]

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.

[Anonymous]

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....

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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