Connecting to Oracle DB from Windows 10 using Oracle Managed Driver .NET

In windows 10 the FIPS ( Federal Information Processing Standards ) policy is enabled by default which means that windows will drop the password part from the database connection string which will give you an error like:

System.Data.Entity.Core.ProviderIncompatibleException: An error occurred accessing the database. This usually means that the connection to the database failed. Check that the connection string is correct and that the appropriate DbContext constructor is being used to specify it or find it in the application's config file. Seehttp://go.microsoft.com/fwlink/?LinkId=386386 for information on DbContext and connections. See the inner exception for details of the failure.

---> System.Data.Entity.Core.ProviderIncompatibleException: The provider did not return a ProviderManifestToken string.

---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01017: invalid username/password; logon denied

To solve this issue we have to disable the FIPS security policy by setting this key in windows registry:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy] to zero



No comments:

Post a Comment