E1: DB: Frequently Asked Questions on SQL Server Installation with EnterpriseOne (Doc ID 1528943.1)

Last updated on NOVEMBER 29, 2023

Applies to:

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

The purpose of this document is to provide assistance when installing SQL Server database in integration with E1 software.

	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

Question 1: Are there any special steps when installing 9.0 database Platform Pack on a SQL Server 2008 database?

Question 2: Are there any limitations for SA password so E1 scripts can run correctly?

Question 3: Is SQL server database clustering supported by Oracle Support?

Question 4: What version of SQL Server Express (SSE) is supported?

Question 5: Is there documentation on how to point an environment to a new SQL server box?

Question 6: How can you copy data from a non SQL database (DB2/400 for example) to a SQL database?

Question 7: Is it possible to use same database server/database for two different setups(Ex: 9.0 and 9.1)? Both these setups will have their own Deployment Server, Enterprise Server, Application Server etc. Database Server will be one with SQL Server installed in it.

Question 8: In SQL Server 2012, the compatibility level of the jde databases is set to 100. Can we increase this to 110?

Question 9: In SQL Server 2016, Can we set the compatibility level of jde database to 130?

Question 10: What are the steps to move business data database from one drive to a different drive on the same server?

Question 11: Is it mandatory to keep old mssql jdbc drivers while using SQL Server 2019?

Question 12: In SQL Server 2022, the compatibility level of the jde databases is set to 100. Can we increase this?

Question 13: In SQL Server 2022, Can we set the compatibility level of jde database to 160?

Question 14: How to find the details production table spaces used by Enterpriseone?

Question 15: Does JD Edwards EnterpriseOne certify Automatic plan correction and Automatic index management?

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