Help: Database Connection Password not persisting correctly.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[Jcs19]

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

[Anonymous]

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.  

[Anonymous]

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.

[Anonymous]

Hi gchaisty,

What's your OS and JDK version? Did this issue repro on other build version studios?
Best regards
Sabrina