[resolved] Connection on MS SQL Server

One Star

[resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

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
One Star

Re: [resolved] Connection on MS SQL Server

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?
Moderator

Re: [resolved] Connection on MS SQL Server

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Connection on MS SQL Server

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

Re: [resolved] Connection on MS SQL Server

Hi,
OK, thanks for your feedback. Feel free post your issue on forum.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.