topic Re: Help: Database Connection Password not persisting correctly. in Talend Studio

Help: Database Connection Password not persisting correctly.

Anonymous — Fri, 25 Jul 2014 19:48:03 GMT

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

Re: Help: Database Connection Password not persisting correctly.

Anonymous — Fri, 25 Jul 2014 19:50:38 GMT

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

Re: Help: Database Connection Password not persisting correctly.

Anonymous — Fri, 25 Jul 2014 20:27:47 GMT

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.

Re: Help: Database Connection Password not persisting correctly.

Jcs19 — Fri, 25 Jul 2014 21:19:55 GMT

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

Re: Help: Database Connection Password not persisting correctly.

Anonymous — Fri, 25 Jul 2014 22:18:19 GMT

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.

Re: Help: Database Connection Password not persisting correctly.

Anonymous — Sat, 26 Jul 2014 02:12:50 GMT

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.

Re: Help: Database Connection Password not persisting correctly.

Anonymous — Mon, 28 Jul 2014 06:02:15 GMT

Hi gchaisty,

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