Login failed when importing data

Usage and Config BFI
1

(imported topic written by JRigas)

Hey all,

I had a user on the remote SQL server which had an ‘&’ in its password, for example ‘tem&Pn’

I used this user to install TEM, and SUA.

Whenever I tried to do an import in SUA, it would have an error in the log that said: 'Login failed for user ‘xxx’ and a few lines below ‘Pn’ (like in the password) is not a valid statement. (or something like that).

So it looks like it would read ‘tem’ as the password, the ‘&’ as an AND statement and the ‘Pn’ as a parameter.

2

(imported comment written by JRigas)

Found the exact error:

Could not connect to DBMS:

Login failed for user ‘xxx’

‘Pn’ is not recognized as an internal or external command.

This was for a user ‘xxx’ with a password like ‘tem&Pn’.

So I’m guessing this is a bug?

3

(imported comment written by DanielGies)

The fact that you were able to install the software with that password suggests the failure is not in how Ruby on Rails connects to the DB, but in how one of the helper utilities is connecting. Could you please email your ETL log(s) so we can identify the point of failure?