E1: DB: Troubleshooting the Error: Login failed for user 'sa'
(Doc ID 1298826.1)
Last updated on FEBRUARY 15, 2023
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 to 9.1 [Release 8.98 to 9.1]
Information in this document applies to any platform.
When installing the EnterpriseOne (E1) Deployment server, FAT (i.e., development) client, or Standalone (demo) client, these installers will also install a local database. This local database resides on the machine where the Deployment server, FAT client, or Standalone client is being installed and is used to store E1 specs and other non-sensitive information. To install the local database, the E1 installer will start another installer that is specific to the particular type of database (SSE or OEE). This database installer will create a database administrator account with a hardcoded, plain-text password.
Starting with E1 Tools Release 8.98.2, the E1 installer was modified to change the MSDE administrator's password to a generated and encrypted password when the database installation is complete. The new password is generated using a proprietary algorithm that is based on the serial number of the "C" drive on the local machine. It is then encrypted using another proprietary algorithm.
The use of this encrypted password provides a level of security against unwanted intrusion into the database. Most access to this database should be performed using E1 applications. Some database administrators may occasionally need access to the database outside of E1 applications, for example to perform some administrative tasks. It was for this reason that ReconfigureMSDE.exe was developed. It allows the user to change the password of the DB administrator's account to an unencrypted string.
When there is an issue with this encrypted password, users will receive an error: Login failed for user 'sa'. This document contains detailed steps to troubleshoot the "Login failed for user 'sa'" issue including information on running ReconfigureMSDE.exe.
Also beginning with EnterpriseOne Application Release 9.1, only the Oracle Enterprise Edition (OEE) database is supported as the local database on the Deployment Server.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Update for Tools Release 9.1:|