This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL Authenticating with Wrong Password

I'm in a test environment and I wanted to see what 1IM would do with a SQL import if the SQL user it's importing with has it's password changed. So I set up an import into some business role objects coming from a SQL Database. Ran the import as normal, everything worked correctly. Then I went into SQL and changed the SQL User account password to be something different so now 1IM has the wrong password. I expected the next time I tried to do a sync it would throw an error but what actually happened is that the sync continued as normal. I thought maybe something was cached so I restarted the SQL service and the 1IM service but the sync still completed successfully. Also, when I click on Target System in the Synchronisation Editor, it gives me an error saying it can't authenticate but when I run it, it does work. What is going on here? How is it importing from SQL while it has the wrong password?

Parents
  • Thanks for the reply George. It does seem like magic. Yes, using SQL Auth. So whether it's encrypted or not it should still be wrong, right? It's not like it can get the new password by decrypting the old password.
Reply
  • Thanks for the reply George. It does seem like magic. Yes, using SQL Auth. So whether it's encrypted or not it should still be wrong, right? It's not like it can get the new password by decrypting the old password.
Children
No Data