10.From the action bar, click Query > Execute. This process will take several minutes to complete. You can verify your results by looking at the final results in the lower half of the form.

8.3.2 Creating Database Logins and Users for SQL Server 7.0

In this section, we begin the creation of SQL Server 7.0 database logins and user IDs for OneWorld B73.3. These logins and users are created using script provided with OneWorld.

To begin, complete the following instructions and later execute the script,

USERS_SQLSRVR.SQL:

1.Open the USERS_SQLSRVR.SQL script, located in the \Oneworld\B733\Database folder.

2.Search for the phrase "Default_DB" and replace it with JDEB733, your default database.

3.Delete the sections of this script you do not need. Your decision should be based on the sections you had removed from the script you modified earlier, DB_SQLSRVR70.SQL.

4.Rename the USERS_SQLSRVR.SQL script and save it. (For our example,

USERS_SQLSRVROK.)

5.On the deployment server, from the Windows desktop click Start > Programs > SQL Server 7.0 > Query Analyzer. Establish a connection to the SQL Server using a database administrator ID and password (for example, JDE).

6.Click File > Open. You will see a screen similar to Figure 139:

Figure 139. Open Query File Screen

7.Locate the file you just edited and saved, USERS_SQLSRVROK.SQL (this file is located in subdirectory d:\OneWorld\B733\Database). Select USERS_SQLSRVROK.SQL and open it.

8.From the action bar, click looking at the final results

Query > Execute. You can verify your results by in the lower half of the form.

192J.D. Edwards’ OneWorld B73.3 and Windows Terminal Server

Page 204
Image 204
IBM B73.3 manual Creating Database Logins and Users for SQL Server, Userssqlsrvr.Sql