E1: DB: Frequently Asked Questions on SQL Server Installation with EnterpriseOne
(Doc ID 1528943.1)
Last updated on AUGUST 18, 2021
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
|Questions and Answers|
|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 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: How to find the details production table spaces used by Enterpriseone?|