My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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



Purpose

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

Questions and Answers

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
Questions and Answers
 Troubleshooting Steps
 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?
References

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