Orphan Users
When you run the orphan user script, you must execute the script first from the master database, and then from each delivered database which could include:
JDE_CRP
JDE_DEVELOPMENT
DV920
PS920
PD920
JDE_PRIST920
JDE_PRODUCTION
PY920
To troubleshoot database connection errors that are reported by JD Edwards EnterpriseOne:
Access Microsoft SQL Query Analyzer and login to the JD Edwards EnterpriseOne database as the JDE user.
If there are database connections problems, an error message appears.
The error is caused by the introduction of a database whose logins do not match those defined within the SQL Server instance as they are defined by a SQL Server internal number or identifier. You must run the following provided script to correct the condition.
From the Microsoft SQL Query Analyzer, click File, Open and navigate to the folder contain the orphan user script.
Typically the file is found in this location:
Z:\JDEdwardsPPack\E920_1\mssql
Select this script:
orphan user with cursor.sql
Click the Open button.
Set the database to master.
Click the Execute Query button.