I have turned on the ‘Store Passwords on SQL Server without encryption’ option and it has not worked? This option can only take effect when a password is changed after the option has been activated. Omni Password will not update all users’ password when the option is turned on. Please change the user’s password via Setup >> System >> Users or Setup >> User Preferences >> Password for the encryption to be removed. You can confirm if the encryption has been removed if you can use the same login to connect via SQL Query Analyser.
Note: The option to store passwords without encryption is not available on v9.0 onwards due to the password security changes made in the core application.