I have turned on the 'Store Passwords on SQL Server without encryption' option and the table is still encrypted?

I have turned on the ‘Store Passwords on SQL Server without encryption’ option and the table is still encrypted? The passwords in the SY_Users_MSTR (SY01400) table will always be encrypted as this is how the table is defined. The bit that is not encrypted is the actual SQL Server passwords stored in the internal SQL Server system. Because the actual SQL Server Password is no longer encrypted, you can use these Login IDs to connect to SQL Server from other applications, such as Crystal Reports, FRx and SQL Query Analyzer.

Note: The option to store passwords without encryption is not available on v9.0 onward due to the password security changes made in the core application.

Related Content