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