Chapter 8. Implementing Microsoft SQL Server 7.0 and OneWorld

In this chapter, we will set up the deployment server for OneWorld. This will allow us to create and maintain installation plans, and deploy OneWorld code to the enterprise server and client workstations. Our configuration includes Microsoft SQL Server 7.0 for Windows NT 4.0 and J.D. Edwards’ OneWorld B73.3. The servers used in this process were IBM’s Netfinity 5500 systems. Prior to the installation of the two software packages, IBM’s ServerGuide (included with all new IBM Netfinity servers) was used to configure the Netfinity 5500 servers and prepare the servers for Microsoft Windows NT Server 4.0.

The OneWorld installation program loads OneWorld on the deployment server, then proceeds to load central objects (specifications) tables into your SQL Server

7.0database.

8.1Deployment Server Setup

In this section, the deployment server will be set up and configured with the required software. The tasks will include the following installations:

Updated BIOS for the IBM Netfinity server

Windows NT 4.0 using IBM’s ServerGuide software

Microsoft Access

Microsoft Visual C++ 5.0

(C++ 6.0 is supported by OneWorld B73.3.1 or higher only)

Microsoft Internet Explorer 4.01 SP1 or higher (Required for MS SQL Server 7.0)

Adobe Acrobat Reader 3.01

Microsoft SQL Server 7.0 Client and Server

Microsoft Internet Server

Before you begin, it is recommended that you download the latest BIOS for your IBM Netfinity server from the IBM Web site:

http://www.pc.ibm.com/us/netfinity

Complete the following steps to set up the deployment server:

1.Install the latest BIOS on your Netfinity server and continue.

2.Using the ServerGuide that came with your machine, set up the hardware and install Windows NT Server 4.0. In addition, install Service Pack 4 or later for Windows NT Server 4.0 and ensure your Y2K software requirements have been met. ServerGuide will configure your hardware and simplify the operating system installation by providing Windows NT with the correct drivers for your machine. See Chapter 6, “Using ServerGuide for IBM Netfinity” on page 79 to help you with these tasks.

3.After Windows NT is installed, a few changes are needed for tuning purposes:

1.From the Windows NT desktop, select Start > Settings > Control Panel.

2.Double-click Network and select the Services tab.

© Copyright IBM Corp. 1999

167

Page 179
Image 179
IBM B73.3 manual Implementing Microsoft SQL Server 7.0 and OneWorld, 167