Federal Information Processing Standards (FIPS) encryption mode not supported
Overview
Windows Federal Information Processing Standards (FIPS) encryption mode is not supported in finPOWER Connect.
Symptoms
When opening an Access database the following message is displayed:
Failed to open Database '[database name]'. Failed to open Database. Failed to initialise Database connection. Not a valid account name or password.
When opening a SQL Server database the following message is displayed:
Failed to open Database '[database name]'. Failed to open database. Failed to execute SQL. Cannot set application role 'appPOWER' because it does not exist or the password is incorrect.
Issue
Windows has a setting that will enable a special government certified "FIPS" encryption mode.
If FIPS mode is enabled, the .NET Framework disallows the use of all non-validated cryptographic classes. The .NET Framework offers multiple implementations of most algorithms, and not all of them have been submitted for validation. This includes algorithms that use managed code, which finPOWER Connect uses.
Solution
Disable FIPS encryption.
Please talk to your Systems Administrator to confirm how to disable.