F1
 About F1Course ScheduleOther ServicesSite MapContactHome

Other Services
  alt="nt.gif (1423 bytes)" border="0" WIDTH="128" HEIGHT="12">
.net
Access
Visual FoxPro & foxpro
Visual Studio
SQL
Visual Basic
Other Courses
mcsd.gif (1348 bytes)
nt.gif (1423 bytes)
nt.gif (1423 bytes)
SQL 7.0 Overview (1140) Set-up guide

Requirements

This course requires a classroom with a minimum of one computer for the instructor and one for each student. Before class begins, install and configure all computers using the information and instructions that follow.

Instructor Computer

The instructor computer requires the following hardware and software configuration.

Hardware

The following hardware is required for the instructor computer:

  • Pentium 133
  • 64 megabytes (MB) of RAM
  • 2-gigabyte (GB) hard disk
  • CD-ROM drive
  • Network adapter
  • Super VGA (SVGA) monitor
  • Internet access
  • Sound card with amplified speakers
  • Microsoft Mouse or compatible pointing device
    1.  

 

Software

The following software is required for the instructor computer:

  • Microsoft® Windows NT® Server version 4.0 and Service Pack 3
  • Microsoft SQL Server™ interim build
  • Microsoft® PowerPoint® Viewer
  • Microsoft® Word Viewer
  • Microsoft® Internet Explorer 4.0
    1.  

 

Student Computer

Each student computer requires the following hardware and software configuration.

Hardware

The following hardware is required for each student computer:

  • Pentium 133
  • 64 MB of RAM
  • 2- GB hard disk
  • CD-ROM drive
  • Network adapter
  • SVGA monitor
  • Internet access
  • Sound card with amplified speakers
  • Microsoft Mouse or compatible pointing device
    1.  

 

Software

The following software is required for each student computer:

  • Microsoft® Windows NT Server version 4.0 and Service Pack 3
  • Microsoft® Internet Explorer 4.0
    1.  

 

Classroom Configuration

The following configuration and naming conventions are used throughout this course and are required for the hands-on labs:

  • The instructor computer is named Instructorx (where x is a number that is unique to the intranet).
  • Each student computer is named in the following way:
    • All computers that are configured as servers are named Serverx (where x is a unique number for each server on the intranet).
  • Each domain is named Domainx (where x is a number that is unique to the intranet).
    1.  

 

If your classroom is on an intranet, make sure that the numbers that you assign to each student computer, instructor computer, domain, and so on are unique. By providing unique numbers for these, you will avoid inadvertently causing naming conflicts.

Setup Instructions

Use the following procedures to prepare each computer for class.

Before You Begin

You will need to do the following:

  • Read through all setup procedures.
  • Make sure that you have the Trainer Materials compact disc provided with the course materials.
    1.  

 

Estimated time to set up the classroom: 3 hours

Instructor Computer Setup

Use the following instructions to set up the instructor computer:

  • To set up the hardware
      1. Set up the hardware according to the manufacturer’s instructions. (Refer to the hardware requirements.)
      2. Configure the hard disk as follows:
    • Drive C: 1.2 GB formatted as FAT (this provides space for multiple configurations if needed)
    • Drive D: 750 MB formatted as Windows NT File System (NTFS)
    • 50 MB unformatted space
    1.  
  • To install and configure Windows NT Server 4.0
      1. Start the computer with the Windows NT Server Setup boot disk.
      2. When prompted, supply the following configuration information.

 

When prompted for

Do this
Partition

Accept C (leave current file system intact).
Location

Accept \Winnt.
Name

Type your name.
Organization

Type your organization’s name.
CD Key

Type the CD Key for your copy of Windows NT Server.
Licensing Modes

Accept Per Server and type 50 concurrent connections.
Computer Name

Type Instructorx (where x is a number that is unique to your intranet).
Server Type

Click Primary Domain Controller.
Administrator Account Password

Type password (all lowercase; necessary for labs).

 

 

(continued)

 

When prompted for

Do this
Floating-point Workaround

Click No (only appears on Pentium-based computers that have floating-point arithmetic problems).
Emergency Repair Disk

Click No (you may want to create an Emergency Repair disk for the Instructor computer).
Select Components

Accept the default components.
Windows NT needs to know how this computer should participate on a network

Click Wired to the network.
Install Microsoft® Internet Information Server

Click No.
Setup to start searching for a Network Adapter

Click Start Search (if Setup cannot detect the installed Network Adapter, click Select from list and configure it manually).
Network Protocols

Select the TCP/IP Protocol and NetBEUI Protocol check boxes.
Clear the NWLink IPX/SPX Compatible Transport check box.
Services (Added to default)

Add to the list of default services: Microsoft DHCP Server and Windows Internet Name Service.
TCP/IP Setup

Click No to specify that the Instructor computer will not be using dynamic host configuration protocol (DHCP) to have the IP address automatically assigned.
IP Address

Type 131.107.2.200 (suggested IP address)
Subnet Mask

Type 255.255.255.0 (suggested subnet mask)
Default Gateway

131.107.2.1 (suggested default gateway)
DNS Domain Name (DNS tab)

In the Domain text box, type the appropriate value for your domain.
DNS Service Search Order

Add the TCP/IP address for the DNS Server in your domain.
Primary WINS Server
(WINS Address tab)

131.107.2.200 (suggested IP address).
Windows NT Domain

Type classroomx (where x is a number that is unique to your intranet).
Time Zone

Specify your time zone.
Display Properties

Specify your display settings.
    1.  
  • To configure the DHCP Server
      1. Log on as Administrator.
      2. Click the Start button, point to Programs, point to Administrative Tools (Common), and then click DHCP Manager.

        3. DHCP Manager appears.

      3. In the DHCP Servers list, double-click Local Machine.
      4. On the Scope menu, click Create.
      5. Configure the DHCP server scope using the following information.
        6. When this information is requested


        Use
        IP address pool, start address

        131.107.2.150 (suggested starting address)
        IP address pool, end address

        131.107.2.199 (suggested ending address)
        Subnet mask

        255.255.255.0 (suggested subnet mask)
      6. In the Lease Duration dialog box, click Unlimited.
      7. Click OK, and when prompted to activate the scope now, click Yes.

        8. A DHCP Manager message box appears, stating that no more data
        is available.

      8. Click OK to close the DHCP Manager message box.
      9. On the DHCP Options menu, click Scope.
      10. In the Unused Options list, click 046 WINS/NBT Node Type, and then click Add.
      11. Click Value, and then in the Byte box, type 0x8
      12. In the Unused Options list, click 044 WINS/NBNS Servers, and then
        click Add.
      13. Click Edit Array.
      14. In the New IP Address box, type 131.107.2.200 (suggested IP address), and then click Add.
      15. Click OK to return to the DHCP Options: Scope dialog box.
      16. Click OK to return to the DHCP Manager dialog box.
      17. Click OK to close the DHCP Manager message box.
      18. Exit DHCP Manager.
    1.  
  • To install Windows NT 4.0 Service Pack 3
      1. Insert the Microsoft Windows NT 4.0 Service Pack 3 compact disc into the CD-ROM drive.
      2. When the NTSP3.htm Web page appears, scroll down, and then click Install Service Pack.

        3. The Confirm File Open dialog box appears.

      3. Click Open.

        4. The Welcome dialog box appears.

      4. Click Next.

        5. The Service Pack Setup dialog box appears.

      5. Click Next.

        6. The Service Pack Setup dialog box appears, asking if you want to create an Uninstall directory.

      6. Verify that Yes, I want to create an Uninstall directory is selected, and then click Next.
      7. Click Finish.

        8. Files are copied.

        The Windows NT Service Pack Setup dialog box appears, stating that Windows NT 4.0 has been updated.

      8. Click OK.

Windows NT Server will shut down and then restart.

    1.  
  • To install and configure SQL Sever interim build
      1. Locate the Setup program using Microsoft® Windows NT Explorer. This can be found in the \Sphinx_442.03\i386 directory.
      2. Start the Setup program and use the information in the following table to complete the installation.
        3. For this installation option

        Use this information
        Local or remote installation

        Local computer (default).
        Type of setup operation

        Install a new SQL Server and Management Tools (default).
        Registration information

        Your name and organization.
        Software License Agreement

        Page down several times and then select "I Agree."
        Installation type

        Typical Installation.
        SQL Server Sphinx Logon Account

        Use the Local System account for the SQL Server Service.
        SQL Server Agent Logon Account

        Use the Local System account for the SQL Server Agent Service.
        Auto Start SQL Server Sphinx Services

        Auto Start SQL Server at boot time.

        Auto Start SQL Server Agent at boot time.
        Confirm Setup Options

        Review your Setup selections, and then click Install Now.
      3. After SQL Server has been installed, click Exit to Windows to close the dialog box.
      4. Shut down your computer and then restart it.
    1.  
  • To install and configure Microsoft® Internet Explorer 4.0
      1. Run the ie4setup.exe Setup application located in \Sphinx_442.03\Ie4 on the compact disc. Use the information in the following table to complete the installation.
        2. For this installation option

        Use this information
        License Agreement

        Accept
        Installation Option

        Standard Installation
        Windows Desktop Update

        No
        Active Channel Selection

        United States (default)
        Destination Folder

        (default)
        Restart Computer

        OK
      2. After Internet Explorer 4.0 is installed, start Internet Explorer 4.0.
      3. The Internet Connection Wizard is automatically displayed. For the convenience of the students, you will step through the Internet Connection Wizard so students do not have to configure Internet Explorer 4.0. They will open local Hypertext Markup Language (HTML) pages.
      4. In the Internet Connection Wizard, select the "I already have an internet connection set up for this computer and I do not want to change it." option.
      5. Click Finish.

        6. The "A connection with the server could not be established." error
        message appears.

      6. Click OK.
    1.  
  • To install fonts for the PowerPoint presentation
      1. Insert the Trainer Materials compact disc in the CD-ROM drive.
      2. Click the Start button, point to Settings, and then click Control Panel.
      3. In Control Panel, double-click the Fonts icon.
      4. In the Fonts window, on the File menu, click Install New Font.
      5. In the Drives box, click your CD-ROM drive.
      6. In the Folders box, double-click the Fonts folder.

        7. The fonts appear in the List of fonts box.

      7. Click the Select All button, and then click OK.
      8. Follow the prompts to install the fonts.
      9. Click OK when all of the fonts are installed.

 

Student Computer Setup

Use the following instructions to set up each student’s computer:

  • To set up the hardware
  • Set up the hardware according to the manufacturer’s instructions. (Refer to the hardware requirements.)
    1.  
  • To install and configure Windows NT Server 4.0
      1. Start the computer with the Windows NT Server Setup boot disk.
      2. When prompted, supply the following configuration information.

 

When prompted for

Do this
Partition

Accept C (leave current file system intact).
Location

Accept \Winnt.
Name

Type your name.
Organization

Type your organization’s name.
CD Key

Type the CD Key for your copy of Windows NT Server.
Licensing Modes

Accept Per Server and type 50 concurrent connections.
Computer Name

Type Serverx (where x is a number that is unique to your intranet).
Server Type

Click Stand alone Server.
Administrator Account Password

Type password (all lowercase; necessary for labs).
Floating-point Workaround

Click No (only appears on Pentium-based computers that have floating-point arithmetic problems).
Emergency Repair Disk

Click No (you may want to create an Emergency Repair disk for the Instructor computer).
Select Components

Accept the default components.
Windows NT needs to know how this computer should participate on a network.

Click Wired to the network.
Install Microsoft® Internet Information Server

Click No.
Setup to start searching for a Network Adapter

Click Start Search (if Setup cannot detect the installed Network Adapter, click Select from list and configure it manually).
Network Protocols

Select the TCP/IP Protocol and NetBEUI Protocol check boxes.
Clear the NWLink IPX/SPX Compatible Transport check box.
TCP/IP Setup

Click Yes to use DHCP.

(continued)

 

When prompted for

Do this
Bindings

Click Next to accept defaults.
Make this computer a member of

Workgroup: WORKGROUP
Time Zone

Specify your time zone.
Display Properties

Specify your display settings.
    1.  
  • To install Windows NT 4.0 Service Pack 3
      1. Insert the Microsoft Windows NT 4.0 Service Pack 3 compact disc into the CD-ROM drive.
      2. When the NTSP3.htm Web page appears, scroll down, and then click Install Service Pack.

        3. The Confirm File Open dialog box appears.

      3. Click Open.

        4. The Welcome dialog box appears.

      4. Click Next.

        5. The Service Pack Setup dialog box appears.

      5. Click Next.

        6. The Service Pack Setup dialog box appears, asking if you want to create an Uninstall directory.

      6. Verify that Yes, I want to create an Uninstall directory is selected, and then click Next.
      7. Click Finish.

        8. Files are copied.

        The Windows NT Service Pack Setup dialog box appears, stating that Windows NT 4.0 has been updated.

      8. Click OK.

Windows NT Server will shut down, and then restart.

    1.  
  • To copy the Trainer Materials compact disc contents to each student computer
      1. Copy the Trainer Materials compact disc contents to each student computer. The following directory contents need to be copied to each student computer.
        1. Copy the \MOC directory and all contents under it to each student computers. This directory contains the northwind database script files.
        2. Copy the \Sphinx_442.03 directory and all contents under it to the student computers. This directory contains all the program files for installing SQL Server 7.0 and Microsoft Internet Explorer 4.0.
      2. By copying the files to the student computers, students will be able to install SQL Server from their own computer in the first lab.
    1.  
  • To install and configure Microsoft Internet Explorer 4.0
      1. Run the ie4setup.exe Setup application located in \Sphinx_442.03\Ie4 on the compact disc. Use the information in the following table to complete the installation.
        2. For this installation option

        Use this information
        License Agreement

        Accept
        Installation Option

        Standard Installation
        Windows Desktop Update

        No
        Active Channel Selection

        United States (default)
        Destination Folder

        (default)
        Restart Computer

        OK
      2. After Internet Explorer 4.0 is installed start Internet Explorer 4.0.
      3. The Internet Connection Wizard is automatically displayed. For the convenience of the students, you will step through the Internet Connection Wizard so students do not have to configure Internet Explorer 4.0. They will open local HTML pages.
      4. In the Internet Connection Wizard, select the "I already have an internet connection set up for this computer and I do not want to change it." option.
      5. Click Finish.

        6. The "A connection with the server could not be established." error message appears.

      6. Click OK.
    1.  

 

Trainer Materials Compact Disc Contents

The Trainer Materials compact disc contains the following files and folders:

  • Readme.txt. This file contains a description of the compact disc contents and setup instructions, saved in ASCII format (non-Word document).
  • Setupgd.doc. This file contains a description of classroom requirements, classroom configuration, and classroom setup instructions.
  • Appendix. This folder contains appendix files for this course.
  • Fonts. This folder contains fonts required to view the PowerPoint presentation and Web-based materials.
  • Ie40. This folder contains files required to install Microsoft Internet Explorer 4.0. Located on \Sphinx_442.03\i386\Ie4.
  • MOC. This folder contains files used in the hands-on labs. Files may be used to prepare the student computers for the hands-on labs.
  • PowerPnt. This folder contains the PowerPoint slides used for this course.
  • PptView. This folder contains the PowerPoint Viewer, which is used to display the PowerPoint slides.
  • WordView. This folder contains the Word Viewer that is used to view any Microsoft® Word document (.doc) files included on the compact disc.

 

PowerPoint Viewer

PowerPoint Viewer is a special application that is shipped with Microsoft PowerPoint and is designed to give electronic slide shows. You can use the Viewer yourself or give it to others who are going to be running your slide shows but do not have PowerPoint. You can freely copy the PowerPoint Viewer program onto any compatible system to allow you to run PowerPoint slide shows.

  • To use the PowerPoint Viewer
      1. Insert the Trainer Materials compact disc into the CD-ROM drive.
      2. Start Windows  NT Explorer, and expand the drive:\PptView folder (where drive is the letter assigned to your CD-ROM drive).
      3. Double-click the PptView.exe file.
      4. After PowerPoint Viewer starts, in the Drives box, click the drive assigned to your CD-ROM drive.
      5. In the Directories box, click PowerPnt.

In the Filename box, click the appropriate PowerPoint file, and then
click Show.

© F1 Computing Systems 2001