Manually Running the Database Creation Scripts - Windows with SQL Server
Once the Platform Pack install has successfully completed on the Windows-based Enterprise Server, the SQL Server database creation scripts and dump files are located on the same disk as the JD Edwards EnterpriseOne install location on the Enterprise Server. For example:
Z:\JDEdwardsPPack\E920_1\mssql
As it runs, the Platform Pack installer edits the script that sets the environment variables. You can review this script for accuracy:
SQL_set.bat
To manually run the SQL Server database installation scripts:
Sign on to the Enterprise Server as a Windows account that is part of the SQLServerxxx groups (there are 3 groups).
Start the
cmd
window with Run As Administrator.Navigate to the
Z:\JDEdwardsPPack\E920_1\mssql
folder as described in the example above.Verify that
DATA_PATH in SQL_set.bat
is set to the parent of the current directory:DATA_PATH=Z:\JDEdwardsPPack\E920_1\mssql
Run the
InstallSQLDatabase.bat
script.Check the logs in the logs directory.