My Oracle Support Banner

E1: DB: Troubleshooting Issues with SSE (SQL Server Express) Local Database (Doc ID 1519511.1)

Last updated on JANUARY 26, 2020

Applies to:

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


Purpose

This document is intended to summarize known issues with local databases (for the Deployment server or FAT clients) when interacting with JD Edwards EnterpriseOne software.

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 1. Login issues on the Deployment Server
 Issue 1: Local databases not attached
 Issue 2: SQL Server does not exist or access denied
 Issue 3: Deployment Server renamed and orphaned users
 
 2. Login issues on FAT client
 Issue 1: Wrong ODBC
 Issue 2: Problems after upgrading from MSDE to SSE
 
 3. Changing local database (migrate, upgrade, etc.)
 Issue 1: How to rename SSE database
 Issue 2: How to upgrade the local database from MSDE to SSE
 Issue 3: Migration path from local databases
 Issue 4: After successful upgrade to SSE, unable to connect to JDEPLAN and jde.log has the following errors,
 4. Password encryption issues
 Issue 1: Login failed for user 'sa'
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.