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

Last updated on AUGUST 08, 2023

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.

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

Applies to:

Purpose

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!