E1: DB: Unable to Login to Client After Upgrading to SSE Due to Invalid Password Error For EnterpriseOne Local ODBC Data Source (Doc ID 1321780.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

The user is unable to login to a FAT Client after the local database has been upgraded from MSDE to SSE (SQL Server Express).  A package is installed on a machine that did not have MSDE previously installed.  The Deployment Server is working fine after upgrading to SSE.

A Database Password Entry pop up box appears when logging into client machine, prompting for UserID and password for the EnterpriseOne Local data source.  The administrator has changed the sa user to the expected encrypted E1 password by running ReconfigureMSDE.exe but when logging into the E1 client, it still fails to login to 'EnterpriseOne Local'. 

The following errors appear in the JDE.LOG:

 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms