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 Implementation (833) Set-up guide

Classroom 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 processor
  • 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
  • Windows NT 4.0 Service Pack 3 (on the Trainer Materials compact disc)
  • Microsoft® SQL Server™ version 7.0 Beta 3 (on the SQL Server 7.0 Beta 3 compact disc)
  • Microsoft® PowerPoint® Viewer (on the Trainer Materials compact disc)
  • Microsoft® Word Viewer (on the Trainer Materials compact disc)
  • Microsoft® Internet Explorer version 4.01 (on the SQL Server 7.0 Beta 3 compact disc)
    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 processor
  • 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 4.0
  • Windows NT 4.0 Service Pack 3 (on the Trainer Materials compact disc)
  • Microsoft SQL Server version 7.0 Beta 3 (on the SQL Server 7.0 Beta 3 compact disc)
  • Microsoft Internet Explorer 4.01 (on the SQL Server 7.0 Beta 3
    compact disc)
    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 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).
  • The password for both the Windows NT administrator account and the sa SQL Server account on the instructor computer is pass833.
    1.  

The classroom setup script assumes that the instructor computer name is "Instructor833." If the name is different, follow the instructions in this setup guide to edit files to reflect the correct computer name.

 

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 following compact discs provided with the course materials: Trainer Materials and SQL Server 7.0 Beta 3.
    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 NTFS file system
    • 50 MB of unformatted space
    1.  
  • To install and configure Windows NT Server 4.0
      1. Start the computer with the Windows NT Server Setup disk.
      2. When prompted, supply the following configuration information.
For this installation option

Use this information
Partition

Drive C (leave current file system intact)
Location

\Winnt
Name

Your name
Organization

Your organization’s name
CD Key

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

Per Server

50 concurrent connections.
Computer Name

Instructor833 (default computer name)
Server Type

Primary Domain Controller
Administrator Account Password

pass833 (all lowercase)

 

(continued)
For this installation option

Use this information
Floating-point Workaround

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

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

Default components
Network participation

Wired to the network
Microsoft® Internet Information Server

No
Network Adapters

Search (if Setup cannot detect the installed network adapter, configure it manually)
Network Protocols

TCP/IP Protocol

NetBEUI Protocol
Additional Network Services

Microsoft DHCP Server

Windows Internet Name Service
DHCP

No

IP Address

192.168.1.200 (default IP address)
Subnet Mask

255.255.255.0 (default subnet mask)
Default Gateway

192.168.1.1 (default default gateway)
DNS Domain (DNS tab)

Your domain name
DNS Service Search Order

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

192.168.1.200 (default IP address)
Bindings

Defaults
Windows NT Domain

Domain833 (default domain name)
Time Zone

Your time zone
Display Properties

Your display settings
    1.  
  • To configure a multimedia sound driver
      1. After Windows NT restarts, log on with a user name of Administrator and a password of pass833.
      2. On the taskbar, click the Start button, point to Settings, and then click Control Panel.
      3. In Control Panel, double-click Multimedia.
      4. Click Devices, and then click Add.
      5. In the List of Drivers, select your sound driver, and then click OK. (If you are unsure of the correct sound driver for your computer, you may try the Creative Labs Sound Blaster 1.X, Pro, 16 driver. This driver works on many Windows NT computers.)
      6. In the Install Driver dialog box, type the path for the Windows NT installation files, and then click OK.
      7. After the sound drivers have been configured, click Restart Now.
    1.  
  • To configure the DHCP server
      1. Log on with a user name of Administrator and a password of pass833.
      2. On the taskbar, click the Start button, point to Programs, point to Administrative Tools (Common), and then click DHCP Manager.
      3. In the DHCP Servers list, double-click Local Machine.
      4. On the Scope menu, click Create.
      5. Configure the DHCP server scope with the following information.
        6. For this installation option

        Use this information
        IP address pool, start address

        192.168.1.150 (default starting address)
        IP address pool, end address

        192.168.1.199 (default ending address)
        Subnet mask

        255.255.255.0 (default 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. Click OK to close the DHCP Manager message box stating that no more data is available.
      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 192.168.1.200 (default 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 run 833_Inst.cmd

This batch file will apply Microsoft Windows NT 4.0 Service Pack 3, and it will copy software to drive C. It will also install Microsoft PowerPoint Viewer, Microsoft Viewer for Word, and additional fonts. After Microsoft Windows NT restarts, it will apply the Microsoft Windows NT 4.0 Mini-Service Pack.

      1. Insert the Trainer Materials compact disc into the CD-ROM drive.
      2. In the root directory of the CD-ROM drive, double-click 833_Inst.cmd and follow the instructions on the screen.
      3. After Service Pack 3 has been applied, Windows NT will restart and apply the Microsoft Windows NT 4.0 Mini-Service Pack.
      4. Click OK when requested to restart Windows NT.
    1.  
  • To install and configure Microsoft Internet Explorer 4.01
      1. After Window NT has restarted, insert the SQL Server 7.0 Beta 3 compact disc into the CD-ROM drive.
      2. When the Microsoft SQL Server dialog box appears, click Install SQL Server 7.0 Prerequisites.
      3. Click Windows NT 4.0 Workstation/Server.
      4. Click Internet Explorer 4.01 Minimal Install.
      5. Use the information in the following table to complete the installation.
        6. For this installation option

        Use this information
        License Agreement

        Accept the agreement
        Active Channel Selection

        None
        Destination Folder

        (default)
      6. Click OK to finish the installation.
      7. Click OK to restart Windows NT.
    1.  
  • To configure domain user accounts and install Microsoft NetShow
      1. After Windows NT restarts, on the taskbar, click the Start button, and then click Run.
      2. In the Open box, type C:\Setup\Users_i.cmd and then click OK.
      3. After the batch file completes, on the taskbar, click the Start button, point to Programs, point to Administrative Tools (Common), and then click User Manager for Domains.

        4. User Manager for Domains appears.

      4. Select all of the users in the Username list.
      5. On the User menu, click Properties.

        6. The User Properties dialog box appears, displaying all of the users.

      6. Clear the User Must Change Password at Next Logon check box.
      7. Click OK.
      8. Close User Manager for Domains.
    1.  
  • To install and configure SQL Server
      1. Insert the SQL Server 7.0 Beta 3 compact disc into the CD-ROM drive.
      2. When the Microsoft SQL Server dialog box appears, click Install SQL Server 7.0 Components.
      3. Click Database Server.
      4. Click Standard.
      5. Use the information in the following table to complete the installation.
        6. For this installation option

        Use this information
        Accept the License Agreement

        Yes
        Name

        Administrator
        Company

        Your company name
        Serial

        Beta 3
        Setup Type

        Typical
        Program Files

        C:\MSSQL7
        Data Files

        C:\MSSQL7
        SQL Server Account

        Same account for all services

        Auto start SQL Server Service
        Service Settings

        Local system account
      6. After SQL Server has been installed, click Yes, I want to restart my computer now, and then click Finish.
    1.  
  • To set the SQL Server sa account password
      1. When Windows NT restarts, log on to Windows NT with a user name of Administrator and a password of pass833.
      2. In the Microsoft Internet Explorer 4.0 dialog box, clear the Show this next time you log in check box.
      3. On the taskbar, click the Start button, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager.
      4. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand Instructor833.
      5. Click Logins, and then in the details pane, double-click sa.
      6. In the Password box, type pass833 and then click OK.
      7. In the Confirm New Password box, type pass833 and then click OK.
      8. Close SQL Server Enterprise Manager.
    1.  
  • To install the library database
      1. On the taskbar, click the Start button, and then click Run.
      2. In the Open box, type C:\MOC\SQL833\Batches\Bldlib 13 Instructor833 pass833 and then click OK. Follow the instructions on the screen.
      3. Log off of Windows NT.
    1.  

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 disk.
      2. When prompted, supply the following configuration information.
For this installation option

Use this information
Partition

Drive C (leave current file system intact)
Location

\Winnt
Name

Studentx (where x is the same number as Serverx)
Organization

Your organization’s name
CD Key

The CD Key for your copy of Windows NT Server
Licensing Modes

Per Server

50 concurrent connections
Computer Name

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

Stand alone Server
Administrator Account Password

password (all lowercase)
Floating-point Workaround

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

No
Select Components

Default components
Network participation

Wired to the network
Microsoft® Internet Information Server

No
Network Adapters

Search (if Setup cannot detect the installed network adapter, configure it manually)
Network Protocols

TCP/IP Protocol

NetBEUI Protocol

DHCP

Yes

Bindings

Defaults
Make this computer a member of

Domain833 (default domain name)

(continued)

For this installation option

Use this information
Create a Computer Account in the Domain

Yes
User Name

Administrator
Password

pass833 (all lowercase)
Time Zone

Your time zone
Display Properties

Your display settings
    1.  
  • To run 833_Stud.cmd

This batch file will apply Microsoft Windows NT 4.0 Service Pack 3, and it will copy software to drive C. After Microsoft Windows NT restarts, it will apply the Microsoft Windows NT 4.0 Mini-Service Pack.

The script file you are about to run assumes that the name of the instructor computer is Instructor833. If it has another name, edit and save the 833_Stud.cmd file in the C:\Setup folder on the instructor computer before you continue.

      1. After Windows NT has restarted, log on to Windows NT with a user name of Administrator and a password of pass833.
      2. Click the Start button, and then click Run.
      3. In the Open box, type \\Instructor833\Setup\833_Stud.cmd and then
        click OK. Follow the instructions on the screen.

        4. If the name of the instructor computer is other than Instructor833, change the preceding step to reflect the name of the instructor computer.

      4. After Service Pack 3 has been applied, Windows NT will restart and apply the Microsoft Windows NT 4.0 Mini-Service Pack.
      5. Click OK when requested to restart Windows NT.
    1.  
  • To install and configure Microsoft Internet Explorer 4.01
      1. After Window NT has restarted, insert the SQL Server 7.0 Beta 3 compact disc into the CD-ROM drive.
      2. When the Microsoft SQL Server dialog box appears, click Install SQL Server 7.0 Prerequisites.
      3. Click Windows NT 4.0 Workstation/Server.
      4. Click Internet Explorer 4.01 Minimal Install.
      5. Use the information in the following table to complete the installation.
        6. For this installation option

        Use this information
        License Agreement

        Accept the agreement
        Active Channel Selection

        None
        Destination Folder

        (default)
      6. Click OK to finish the installation.
      7. Click OK to restart Windows NT.
    1.  
  • To configure local user rights for domain user accounts for each student computer
      1. After Windows NT restarts, on the taskbar, click the Start button, point to Programs, point to Administrative Tools (Common), and then click User Manager for Domains.
      2. On the User menu, click Select Domain.
      3. In the Domain box, type Serverx (where x is the number of the server on the intranet), and then click OK.
      4. In the Groups list, double-click Administrators.
      5. Click Add.

        6. The Add Users and Groups dialog box appears.

      6. Double-click Studentx (where x is the number of the server on the intranet).

        7. The Studentx account appears in the Add Names list.

      7. Click OK to close the Add Users and Groups dialog box.
      8. Click OK to close the Local Group Properties dialog box.
      9. Close User Manager for Domains.
    1.  
  • To install and configure SQL Server
      1. Insert the SQL Server 7.0 Beta 3 compact disc into the CD-ROM drive.
      2. When the Microsoft SQL Server dialog box appears, click Install SQL Server 7.0 Components.
      3. Click Database Server.
      4. Click Standard.
      5. Use the information in the following table to complete the installation.
        6. For this installation option

        Use this information
        Accept the License Agreement

        Yes
        Name

        Studentx (where x is the same number as Serverx)
        Company

        Your company name
        Serial

        Beta 3
        Setup Type

        Typical
        Program Files

        C:\MSSQL7
        Data Files

        C:\MSSQL7
        SQL Server Service Account

        Same account for all services

        Auto start SQL Server Service
        Service Settings

        Local system account
      6. After SQL Server has been installed, click Yes, I want to restart my computer now, and then click Finish.
      7. After Windows NT restarts, log on with a user name of Studentx (where x is the same number as Serverx) and a password of password.
      8. After Microsoft Internet Explorer 4.01 is configured, log off of Windows NT.
    1.  

Trainer Materials Compact Disc Contents

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

  • Default.htm. This file opens the course Web page.
  • ErrorLog. This folder contains a template used to record errors and corrections that you may find in the course.
  • Readme.txt. This file contains a description of the CD-ROM contents and setup instructions, saved in ASCII format (non-Word document).
  • MOCAutoInstall. This folder contains files that are used to expedite the setup of the classroom, including Microsoft Windows NT 4.0 Service
    Pack 3.
  • SG_833.doc. This file contains a description of classroom requirements, classroom configuration, and classroom setup instructions.
  • StudentCD. This folder contains the Web page that provides students with links to resources pertaining to this course including additional readings, review and lab answers, lab files, multimedia presentations, and course-related Web sites.
  • Tprep. This folder contains the narrated slide show that explains how to deliver this course.

 

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. On the Programs menu, click Microsoft PowerPoint Viewer.
      2. After PowerPoint Viewer starts, in the Look in box, select your drive C.
      3. In the Directories box, click PowerPnt.
      4. In the File name box, click the appropriate PowerPoint file, and then click Show.

 

 


© F1 Computing Systems 2006