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:

1. 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.

2. 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
   

3. Select this script:

   orphan user with cursor.sql 
   

4. Click the Open button.

5. Set the database to master.

6. Click the Execute Query button.