One Star

Help: Database Connection Password not persisting correctly.

I setup my database connection, I hit Check and it works.
I then edit the same database connection, making no changes, and click Check and I get "Connection failure.  You must change the Database Settings."
Connection failure. You must change the Database Settings.
  java.lang.RuntimeException: java.sql.SQLException: Login failed for user 'sa'.
If I then change the password back, it works again.
I then hit Finish to save it, go back to it, and it won't work.
This is preventing me from doing Retrieve Schema, as it gives me the same error.


talend_error_connecting_to_db.txt_20140725-2047.txt
6 REPLIES
One Star

Re: Help: Database Connection Password not persisting correctly.

Talend Open Studio 5.5.1
Build r118616-20140617-1110
SQL Server 2008 R2
One Star

Re: Help: Database Connection Password not persisting correctly.

Connecting to Oracle persists fine, and am able to reconnect.
Tested against a different SQL Server 2008 R2 instance, same results as with my local development machine.  Works on initial connect, fails on subsequent attempts.
One Star

Re: Help: Database Connection Password not persisting correctly.

Make sure you have the read right for this user on your database
One Star

Re: Help: Database Connection Password not persisting correctly.

Make sure you have the read right for this user on your database

It's sa, he has all permissions.
I can setup a profiler on SQL Server and see the failed authentication.  
One Star

Re: Help: Database Connection Password not persisting correctly.

Oddly enough, if I pull in the tMSSqlConnection from the Palette, it works, and I can export as HTML and see the password.
Also, if I go into the DB connection and "Export as context" it also works.
Moderator

Re: Help: Database Connection Password not persisting correctly.

Hi gchaisty,

What's your OS and JDK version? Did this issue repro on other build version studios?
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.