© Copyright IBM Corp. 1999 167
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.0 database.
8.1 Deployment 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.