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 Administration (832) 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 166 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

Software
The following software is required for the instructor computer:

  • Microsoft® Windows NT® Server version 4.0
  • Windows NT 4.0 Service Pack 4 (on the Trainer Materials compact disc)
  • Microsoft® SQL Server version 7.0 (on the SQL Server 7.0 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 SP1 (on the SQL Server 7.0 compact disc)
  • Microsoft® Outlook® 98
  • Microsoft® Exchange Server version 5.5 (on the Exchange Server version 5.5 compact disc)

Student Computer
Each student computer requires the following hardware and software configuration.

Hardware
The following hardware is required for each student computer:

  • Pentium 166 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

Software
The following software is required for each student computer:

  • Microsoft Windows NT Server 4.0 (40-bit version) with SP4
  • Microsoft SQL Server version 7.0
  • Microsoft Internet Explorer 4.01 SP1
  • Microsoft Outlook 98

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 pass832.

The classroom setup script assumes that the instructor computer name is "Instructor832." 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, SQL Server 7.0, and Exchange Server 5.5.
  • Make sure that you have Microsoft Windows NT Server 4.0 (40-bit version) and Outlook 98.

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
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

Instructor832 (default computer name)

Server Type

Primary Domain Controller

Administrator Account Password

pass832 (all lowercase)

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

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 Domain832 (default domain name)
Time Zone Your time zone
Display Properties Your display settings (256 colours)

To configure a multimedia sound driver
  1. After Windows NT restarts, log on with a user name of Administrator and a password of pass832.
  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 Don't Restart Now.
  8. Click OK to close the Multimedia Properties dialog box.
To configure the DHCP server
  1. On the taskbar, click the Start button, point to Programs, point to Administrative Tools (Common), and then click DHCP Manager.
  2. In the DHCP Servers list, double-click Local Machine.
  3. On the Scope menu, click Create.
  4. Configure the DHCP server scope with the following information.
  5. 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.
To run 832_Inst.cmd
This batch file will apply Microsoft Windows NT 4.0 Service Pack 4, 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 832_Inst.cmd and follow the instructions on the screen.
  3. After Service Pack 4 has been applied, Windows NT will restart and apply the Microsoft Windows NT 4.0 Mini-Service Pack.
To install and configure Microsoft Internet Explorer 4.01 SP1
  1. After Window NT has restarted, insert the SQL Server 7.0 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.
  4. Click 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)

  7. Click No to All when prompted to overwrite the newer file.
  8. Click OK to finish the installation.
  9. Click OK to restart Windows NT.
To copy and install Microsoft Outlook 98

1.     After Windows NT restarts, open Windows Explorer.
2.     Create a folder in the root of the C drive entitled Outlook98.
3.     Share the Outlook98 folder as Outlook98 using the default permissions.
4.     Insert your Outlook98 compact disc into the CD-ROM.
5.     Copy the contents of \EN\OL98 folder on the Outlook98 compact disc into the C:\Outlook98 folder.These files will be used to expedite the installation of Outlook98 on each of the student computers.
6.     After Outlook98 has been copied to your hard drive, click the Start button and then click Run.
7.     In the Open box, type C:\Outlook98\Setup and then click OK.
8.     Use the information in the following table to install Outlook 98.

For this installation option

Use this information

License Agreement

Accept

Name

Administrator

Organization

Your organization name

Installation Option

Minimal Installation

E-mail Upgrade Options

None of the above

E-mail Service Options

Corporate or Workgroup

Install in Folder

Default path

Upgrade new items

Upgrade only newer items

 9.     After Microsoft Outlook 98 has been installed, click OK to restart Windows NT.
10. After Windows NT restarts, clear the Show this next time you log in
check box, and then close the Welcome – Microsoft Internet Explorer dialog box.
11. On the desktop, double-click Internet Explorer.
12. The Internet Connection wizard appears.
13. Click I already have an Internet connection set up for this computer and I do not want to change it, and then click Finish.
The “A connection with the server could not be established” error
message appears.
14. Click OK.
15. Close Microsoft Internet Explorer.

To configure domain user accounts and install Microsoft Windows NT Media Player

  1. 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. User Manager for Domains appears.
  4. Select all of the users in the Username list.
  5. On the User menu, click Properties.
    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.

To install and configure Microsoft Exchange Server

1.     Insert the Exchange Server 5.5 compact disc into the CD-ROM drive.
2.     When the Microsoft Exchange Server dialog box appears, click Setup Server and Components.
3.     Click Microsoft Exchange Server 5.5.
4.     Use the information in the following table to complete the installation.

For this installation option

Use this information

License Agreement

Accept

Setup Type

Typical

Per Seat License Agreement

Agree

Organization and Site

New site

Organization

SQL7

Site Name

Domain832

New site

Yes

Site Service Account Name

DOMAIN832\ExService
(click Browse and select ExService)

Site Service Account Password

exservice

Run Optimizer / Exit Setup

Exit Setup

 5.     After Microsoft Exchange Server 5.5 has been installed, click Exit to close the Microsoft Exchange Server dialog box.
6.    
On the taskbar, click the Start button, point to Programs, point to Microsoft Exchange, and then click Microsoft Exchange Administrator.
7.     In the Connect to Server dialog box, click Browse.
8.     Double-click Instructor832, and then click OK.
9.     On the Tools menu, click Directory Import.
10. Click Import File.
11. In the File name box, type C:\Setup\Exchange832 and then click Open.
12. Click Import.
13. Click OK to acknowledge that no errors were encountered.
14. Close Microsoft Exchange Administrator.

To configure a Microsoft Exchange profile for the Administrator account

1.     On the desktop, double-click Microsoft Outlook.
2.     Use the information in the following table to complete the installation.

For this installation option

Use this information

Information Services

Microsoft Exchange Server

Microsoft Exchange Server

Instructor832 (default computer name)

Mailbox

Administrator

Do you travel with this computer

No

Personal Address Book path

Default path

Add to Startup Group

No

3.     When the Location Information dialog box appears, type your area code, and then click Close.
4.     Click Yes to register Microsoft Outlook 98 as the default manager for Mail, News, and Contacts.
5.     Clear the Show these choices at startup check box, and then click OK.
6.     Exit and log off of Microsoft Outlook 98.
7.     On the desktop, double-click Stop.
Warning Do not restart Windows NT at this point in time.

To install and configure SQL Server

  1. Insert the SQL Server 7.0 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 - Standard Edition.
  4. Use the information in the following table to complete the installation.

For this installation option

Use this information

Install method

Local install

License agreement

Accept

Name

Administrator

Company

Your company name

Setup type

Typical

Destination folder

Default path

Services accounts

Same account for all services
Auto start SQL Server Service

Service settings

Domain user account

User name

SQLService

Password

sqlservice

Domain

domain832 (default domain name)

Licensing mode

Per server

Number of licenses

50

  1.  After SQL Server has been installed, click Yes, I want to restart my computer now, and then click Finish.

  To configure a Microsoft Exchange profile for the SQLService account

1.     After Windows NT restarts, log on to Windows NT with a user name of SQLService and a password of sqlservice.
2.     Click Close to close the Welcome to Windows NT dialog box.
3.     After Internet Explorer has been configured, on the desktop, double-click Microsoft Outlook.
4.     Use the information in the following table to complete the installation.

For this installation option

Use this information

Information Services

Microsoft Exchange Server

Microsoft Exchange Server

Instructor832 (default computer name)

Mailbox

SQLService

Do you travel with this computer

No

Personal Address Book path

Default path

Add to Startup Group

No

5.  Exit and log off of Microsoft Outlook 98.

To configure SQL Server Agent and SQLAgentMail

1.     On the taskbar, click the Start button, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager.
2.     Expand Microsoft SQL Servers, expand SQL Server Group, and then expand Instructor832.
3.     Right-click Instructor832, and then click Properties.
4.     Select the Autostart SQL Server Agent check box, and then click OK.
5.     Expand Management.
6.     Right-click SQL Server Agent, and then click Properties.
7.     In the Mail Profile box, select the MS Exchange Settings profile.
8.     Click Test.
9.     Click OK to acknowledge that a MAPI session was successfully started
and stopped.
10. Click OK to close the SQL Server Agent Properties dialog box.
11. Right-click SQL Server Agent, and then click Start.

To set the SQL Server sa account password

  1. Expand Security, and then click Logins, and then in the details pane, double-click sa.
  2. In the Password box, type pass832 and then click OK.
  3. In the Confirm New Password box, type pass832 and then click OK.
  4. Close SQL Server Enterprise Manager.
  5. Log off Windows NT

To log on as Administrator and stop the Microsoft Exchange services

1.     Log on to Windows NT with a user name of Administrator and a password of pass832.
2.     On the desktop, double-click Stop.

To configure the display settings

1.     In Control Panel, double-click Display.
2.     Click Settings.
3.     Verify the Color Palette setting is set to 256 colors.
4.     If it is not, click Display Type, and then click Change.
5.     Install the drivers for your video card.
6.     If requested, restart Windows NT and when Windows NT restarts, log on as Administrator and configure the new video driver for 256 colors.
7.     Log off of Windows NT.

The instructor computer is now ready for class.

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.)

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.
  3. 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

    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

    DHCP

    Yes

    Bindings

    Defaults

    Make this computer a member of

    domain832 (default domain name)

    Create a computer account in the domain

    Yes

    User name

    Administrator

    Password

    pass832

    Time zone

    Your time zone.

    Display properties

    800 x 600

To run 832_Stud.cmd

This batch file will apply Microsoft Windows NT 4.0 Service Pack 4, and it will copy software to drive C. 

The script file you are about to run assumes that the name of the instructor computer is Instructor832. If it has another name, edit and save the 832_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 pass832.
  2. Click the Start button, and then click Run.
  3. In the Open box, type \\Instructor832\Setup\832_Stud.cmd and then
    click OK. Follow the instructions on the screen.
    If the name of the instructor computer is other than Instructor832, change the preceding step to reflect the name of the instructor computer.
  4. After Service Pack 4 has been applied, Windows NT will restart.

To install and configure Microsoft Internet Explorer 4.01

  1. After Window NT restarts, insert the SQL Server 7.0 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.
  4. Click 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)

  7. Click No to All when prompted to overwrite the newer file.
  8. Click OK to finish the installation.
  9. Click OK to restart Windows NT.

To install Microsoft Outlook 98

1.     After Windows NT restarts, click the Start button and then click Run.
2.     In the Open box, type C:\Outlook98\Setup and then click OK.
3.     Use the information in the following table to install Outlook 98.

For this installation option

Use this information

License Agreement

Accept

User Name

Studentx (where x is the same number as Serverx)

Organization

Your organization name

Installation Option

Minimal Installation

E-mail Upgrade Options

None of the above

E-mail Service Options

Corporate or Workgroup

Install in Folder

Default path

Upgrade new items

Upgrade only newer items

4.     After Microsoft Outlook 98 has been installed, click OK to restart Windows NT.
5.     After Windows NT restarts, clear the Show this next time you log in
check box, and then close the Welcome – Microsoft Internet Explorer dialog box.
6.     On the desktop, double-click Internet Explorer.
7.     The Internet Connection wizard appears.
8.     Click I already have an Internet connection set up for this computer and I do not want to change it, and then click Finish.
The “A connection with the server could not be established” error
message appears.
9.     Click OK.
10. Close Microsoft Internet Explorer.

To configure the desktop area

1.     When Windows NT restarts, open Control Panel.
2.     Double-click Display, and then click Settings.
3.     Set the desktop area to 800 x 600 pixels.
4.     Click Test, and then click OK.
5.     Click Yes if you saw the test bitmap properly.
6.     Click OK to close the Display Properties dialog box.
7.     Log off of Windows NT.

To configure Windows NT user profiles for Carl, Max, and Studentx

1.     Log on to Windows NT with a user name of Carl and a password
of password
2.     After Microsoft Internet Explorer is configured, log off of Windows NT.
3.     Log on to Windows NT with a user name of Max and a password
of password
4.     After Internet Explorer is configured, log off of Windows NT.
5.     Log on to Windows NT with a user name of Studentx (where x is the same number as Serverx) and a password of password
6.     After Microsoft Internet Explorer is configured, log off of Windows NT.

The student computer is now ready for class.

 

 


© F1 Computing Systems 2001