ORA-01017 Error in SSMA for Oracle

Question

I am trying to leverage SSMA for Oracle and am running to an ORA-01017: Invalid username/password; logon denied error when trying to connect to the Oracle dB. A UDL connection to the Oracle dB from the same machine and with the same credentials works fine. FIPS is not enabled so using the unmanaged data access library, and I've set the username/password to all CAPS in the Oracle dB itself to overcome the possibility of case sensitivity and the .NET provider forcing to uppercase. The Oracle dB is 10g. No issues connecting to SQL Server through the SSMA client. HELP!!

Answer 1

Hi @Keith Steflik,

a) you have contacted the wrong database. This might be "indirectly" wrong. For example, if you are using a entry from a tnsnames.ora file then you might be pointing at the wrong file.

b) your username is wrong.

c) your password is wrong (passwords are typically case-sensitive depending on your settings).

Please also make sure that you have allowed to use the account to connect from a remote machine.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Keith Steflik,

I have same problem. No solution found yet, but for me works using connection string (Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;) https://www.connectionstrings.com/oracle/ to log in Oracle DB