How to set a password via SQL Remote passthrough mode for an older remote

[VolkerBarth]

With SQL Remote's passthrough mode, it's easy to reset a password for a remote, e.g. something like

:::SQL
PASSTHROUGH ONLY FOR <TheRemote>;
   setuser dbo;
   grant connect to "DBA" identified by 'SQL';
   commit;
PASSTHROUGH STOP;

However, when using a newer consolidated (v10 and up), the newly created password will be SHA256-hashed, and will be send in encrypted form to the remotes. Naturally, pre-v10 remotes won't recognized that format, and will reject the GRANT CONNECT statement.

So how do you set the password in a compatible manner?

[VolkerBarth · Accepted solution]

You need to use an pre-10 database and set the password there (not in passthrough mode).

Then you have to check the log (via DBTRAN) for the according encrypted GRANT CONNECT statement, something like

 :::SQL
 GRANT CONNECT TO DBA IDENTIFIED BY ENCRYPTED '...';

Use that exact statement (i.e. the encrypted part) in the passthrough statement, as it will be sent as-is and will contain the password in the former proprietary format used by pre-10 databases.

And breathe deep:)