 |
 |
 |
 |
 |
 |
 |
 |  |
 |  |
alt="nt.gif (1423 bytes)" border="0" WIDTH="128" HEIGHT="12">
|
 |
SQL 7.0 Data Warehousing
(1502) Set-up guideClassroom 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.
All Classroom Computers
The instructor and student computers require the following hardware and software
configuration.
Hardware
The following hardware is required for the instructor computer:
- Pentium 166 processor
- 128 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 (40-bit version) with Service Pack 3
(SP3) (SP3 is on the Trainer Materials compact disc)
- Microsoft Windows NT 4.0 Option Pack
- Windows NT Server Service Pack 4 (SP4) (SP4 is on the Trainer Materials compact
disc)
- Microsoft SQL Server version 7.0 (on the SQL Server 7.0 compact
disc)
- SQL Server OLAP Services (on the SQL Server 7.0 compact disc)
- Microsoft English Query (on the SQL Server 7.0 compact disc)
- Microsoft PowerPoint® Viewer (on the
Trainer Materials compact disc)
- Microsoft Viewer for Word (on the Trainer Materials compact disc)
- Microsoft Internet Explorer version 4.01 SP1 (on the SQL Server 7.0 compact disc)
- Microsoft Access 9, Microsoft Excel 9, and MS Query from Microsoft Office 2000, Beta 2
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). The administrator password is pass1502.
- Each student computer is named serverx (where x is a unique number
for each server on the intranet). The administrator password is password.
- Each computer is a stand alone Windows NT Server.
- The password for the SQL Server sa login account on each computer
is blank.
The classroom setup script assumes that the instructor computer name is instructor.
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.
- Make sure that you have Microsoft Windows NT Server 4.0
(40-bit version), Microsoft Windows NT 4.0 Option Pack and Office 2000 Beta 2, CD 1.
Estimated time to set up the classroom: 4 hours
Instructor Computer Setup
Use the following instructions to set up the instructor computer.
- Set up the hardware according to the manufacturers instructions. (Refer to the
hardware requirements.)
- Configure the hard disk as follows:
- Drive C: 2.0 GB formatted as FAT (file allocation table)
-
- To install and configure Windows NT Server 4.0
- Start the computer with the Windows NT Server setup disk.
- When prompted, supply the following configuration information.
| For this installation option |
Use this information
|
|
| Partition |
Drive C (format file system to NTFS)
|
| Location |
\Winnt
|
| Name |
Instructor
|
| Organization |
Your organizations name
|
| CD key |
The CD Key for your copy of Windows NT Server
|
| Licensing modes |
Per server
50 concurrent connections
|
| Computer name |
Instructor (default computer name)
|
| Server type |
Stand alone server
|
| Administrator account password |
pass1502
|
| 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
|
(continued)
| For this installation option |
Use this information
|
|
| Microsoft Internet Information Server |
Yes
|
| 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 gateway)
|
| DNS Domain (DNS tab) |
WORKGROUP
|
| 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
|
| Make this computer a member of the workgroup |
WORKGROUP
|
| Internet Information Server Components |
Internet Service Manager
World Wide Web Service
|
| Internet Information Server file location |
Default location
|
| Time zone |
Your time zone
|
| Display properties |
Your display settings (minimum of
256 colors)
|
-
- To configure a multimedia sound driver
In this procedure, you will install a multimedia sound driver for Windows NT. This
is required for the multimedia presentation files.
- After Windows NT restarts, log on with a user name of Administrator and a
password of pass1502.
- On the taskbar, click the Start button, point to Settings, and then click Control
Panel.
- In Control Panel, double-click Multimedia.
- Click Devices, and then click Add.
- In the List of Drivers, click 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 computers running
Windows NT.)
- In the Install Driver dialog box, type the path for the installation files, and
then click OK.
- After the sound drivers have been added and configured, click Dont Restart
Now.
- Click OK to close the Multimedia Properties dialog box.
-
- To configure the DHCP server
In this procedure, you will configure the DHCP service. This is required for the
student computers to obtain TCP/IP addresses.
- On the taskbar, click the Start button, point to Programs, point to Administrative
Tools (Common), and then click DHCP Manager.
- In the DHCP Servers list, double-click Local Machine.
- On the Scope menu, click Create.
- Configure the DHCP server scope with the following information.
| 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)
|
- In the Lease Duration dialog box, click Unlimited.
- Click OK, and when prompted to activate the scope now, click Yes.
- Click OK to close the DHCP Manager message box stating that no more data
is available.
- On the DHCP Options menu, click Scope.
- In the Unused Options list, click 046 WINS/NBT Node Type, and then click Add.
- Click Value, and then in the Byte box, type 0x8.
- In the Unused Options list, click 044 WINS/NBNS Servers, and then
click Add.
- Click Edit Array.
- In the New IP Address box, type 192.168.1.200 (default IP address), and
then click Add.
- Click OK to return to the IP Address Array Editor dialog box.
- Click OK to return to the DHCP Options: Scope dialog box.
- Click OK to close the DHCP Manager message box.
- Exit DHCP Manager.
-
In this procedure, you will execute the 1502_Ins.cmd batch file. This batch
file will apply Windows NT 4.0 SP3, and it will copy software to drive C.
SP3 is being installed before SP4 because SP3 is required for the Microsoft
Windows NT 4.0 Option Pack, and SP4 modifies the Microsoft
Windows NT 4.0 Option Pack. It will also install Microsoft PowerPoint Viewer, Microsoft
Viewer for Word and additional fonts. Pauses have been placed into this batch file to
allow you to observe any errors if they occur.
- Insert the Trainer Materials compact disc into the CD-ROM drive.
- Using Windows Explorer, in the root directory of the CD-ROM drive, double-click 1502_Ins
and follow the instructions on the screen.
This is the 40-bit version of SP3. If you have installed the 128-bit version of
Windows NT 4.0 Server, cancel the batch file when it is ready to install the service
pack, and install the 128-bit version of the service pack.
- After SP3 has been applied, Windows NT will restart.
-
- To install and configure Internet Explorer 4.01 SP1
In this procedure, you will install Internet Explorer 4.01 SP1. Internet
Explorer 4.01 SP1 is required for the Windows NT 4.0 Option Pack and SQL Server 7.0.
- After Window NT restarts, clear the Show this Welcome Screen next time you start
Windows NT check box, and then click Close.
- Insert the SQL Server 7.0 compact disc into the CD-ROM drive.
- When the Microsoft SQL Server dialog box appears, click Install SQL Server
7.0 Prerequisites.
- Click Windows NT 4.0.
- Click Minimal Install.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| License agreement |
Accept
|
| Active channel selection |
None
|
| Destination folder |
Default path
|
- Click OK to finish the installation.
- Click OK to restart Windows NT.
-
- To install and configure Microsoft Windows NT 4.0 Option Pack
In this procedure, you will install Microsoft Windows NT 4.0 Option Pack. This is
required for classroom labs.
- After Windows NT restarts, insert the Windows NT 4.0 Option Pack compact disk into
the CD-ROM drive.
- Using Windows Explorer, open the Ntoptpak\En\X86\Winnt.srv folder, and double-click Setup.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| License agreement |
Accept
|
| Upgrade |
Upgrade Plus
|
| Select components |
Front Page 98 Extensions and its defaults
Internet Information Server (IIS) and its defaults
Microsoft Data Access Components 1.5 and
its defaults
Microsoft Management Console
Windows NT Option Pack Common Files
Microsoft Transaction Server and all subcomponents
|
| MTS destination folder |
Default path
|
| Administration account |
Local
|
- Click Finish to finish the installation.
- After Microsoft Windows NT 4.0 Option Pack has been installed, click Yes to
restart the computer.
-
- To apply Windows NT 4.0 SP4
In this procedure, you will apply Windows NT SP4.
- 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.
- In the command prompt dialog box, press any key to apply
Windows NT 4.0 SP4.
This is the 40-bit version of SP3. If you have installed the
128-bit version of Windows NT 4.0 Server, cancel the batch file when it is ready to
install the service pack, and install the 128-bit version of the service pack.
Windows NT will restart after SP4 has been applied.
-
- To install and configure Microsoft SQL Server 7.0
In this procedure, you will install Microsoft SQL Server 7.0
- After Windows NT restarts, insert the SQL Server 7.0 compact disc into the CD-ROM
drive.
- When the Microsoft SQL Server dialog box appears, click Install SQL Server
7.0 Components.
- Click Database Server Standard Edition.
- 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 |
Custom
|
| Destination folder |
Default path
|
| Components and sub-components |
Select all components and sub-components
|
| Character set (Use default) |
ISO Character Set
|
| Sort order (Use default) |
Dictionary order, case-insensitive
|
| Unicode collation (Use defaults) |
General Unicode, case-insensitive,
width-insensitive, Kana-insensitive
|
| Network libraries ( Use defaults) |
Named Pipes (use default pipe)
TCP/IP Sockets (use default port)
Multiprotocol
|
| Services accounts |
Same account for all services
Auto start SQL Server service
|
| Service settings |
Domain user account
|
| User name |
Administrator
|
| Password |
pass1502
|
| License mode |
Per seat
|
- After SQL Server has been installed, click Finish.
-
- To install and configure Microsoft SQL Server 7.0 OLAP Services
In this procedure, you will install Microsoft SQL Server 7.0 OLAP Services.
- Click SQL Server 7.0 OLAP Services.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Accept the License Agreement |
Yes
|
| CD key |
111-1111111
|
| Services destination folder |
Default path
|
| Data destination folder |
Default path
|
| Select Components |
All components
|
| Program folder |
Default folder
|
- Click Yes to overwrite the read only file.
- After OLAP Services setup completes successfully, click OK.
- After OLAP Services has been installed, click No, I will restart my computer later,
and then click OK.
-
- To install and configure Microsoft English Query
In this procedure, you will install Microsoft English Query.
- Click English Query.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Destination folder |
Default path
|
| License agreement |
Agree
|
| Setup type |
Complete
|
- After English Query setup is completed successfully, click OK.
- Click Exit to close the SQL Server 7.0 Install SQL Server 7.0 dialog
box.
-
- To install and configure Office 2000 components
In this procedure, you will install and configure Office 2000 components
- Insert the Office 2000 Beta 2, CD 1 compact disc into the CD-ROM drive.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Customer information |
Default information
|
| Setup options |
Customize
|
| Installation location |
Default path
|
| Internet Explorer 5.0 |
Standard installation
|
| Components to Install |
Make sure that the installation options
for the following components are set to Run from My Computer:
Microsoft Excel
Microsoft Access
MS Query (Under Office Tools)
Do not install Microsoft Word for Windows, Microsoft PowerPoint
for Windows, Microsoft Outlook for Windows, or Microsoft Front page
for Windows.
|
- Click Yes to restart the computer.
-
- To complete the installation of the instructor computer
In this procedure, you will finish the installation of Office 2000 components and
install Microsoft Windows NT Media Player.
- After Windows NT restarts, and after Office 2000 and Internet Explorer 5.0 complete
their installation, in the command prompt dialog box, press any key to install Microsoft
Windows NT Media Player.
The instructor computer is ready for class.
Student Computer Setup
Use the following instructions to set up each students computer.
- Set up the hardware according to the manufacturers instructions. (Refer to the
hardware requirements.)
- Configure the hard disk as follows:
- Drive C: 2.0 GB formatted as FAT
-
- To install and configure Windows NT Server 4.0
- Start the computer with the Windows NT Server setup disk.
- When prompted, supply the following configuration information.
| For this installation option |
Use this information
|
|
| Partition |
Drive C (format the file system to NTFS)
|
| Location |
\Winnt
|
| Name |
studentx (where x is the same number as serverx)
|
| Organization |
Your organizations 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 |
pass1502
|
| Emergency repair disk |
No
|
| Select components |
Default components
|
| Network participation |
Wired to the network
|
| Microsoft Internet Information Server |
Yes
|
| 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 the workgroup |
DWSTUDENTx (where x is a number that
is unique to your intranet)
|
| Internet Information Server Components |
Internet Service Manager
World Wide Web Service
|
(continued)
| For this installation option |
Use this information
|
|
| Internet Information Server File Location |
Accept Defaults
|
| Time Zone |
Your time zone
|
| Display Properties |
Your display settings
|
-
In this procedure, you will execute the 1502_Std.cmd batch file. This batch
file will apply Microsoft Windows NT 4.0 SP3, and it will copy software to drive C. Pauses
have been placed into this batch file to allow you to observe any errors if they occur.
The script you are about to run assumes that the name of the instructor computer is
Instructor. If it is not, edit and save the 1502_Std.cmd and SP4_S.cmd files in the
C:\Setup folder on the instructor computer before you continue.
After Windows NT restarts, log on to Windows NT with a user name of Administrator
and a password of pass1502.
On the taskbar, click the Start button, and then click Run.
In the Open box, type \\Instructor\Setup\1502_Std and then click OK.
Follow the instructions on the screen.
If the name of the instructor computer is other than Instructor, change the preceding
step to reflect the name of the instructor computer.
This is the 40-bit version of SP3. If you have installed
the 128-bit version of Windows NT 4.0 Server, cancel the batch file when it is ready
to install the service pack, and install the 128-bit version of the service pack.
After Service Pack 3 has been applied, Windows NT will restart.
To install and configure Microsoft Internet Explorer 4.01 SP1
In this procedure, you will install Internet Explorer 4.01 SP1. Internet
Explorer 4.01 SP1 is required for SQL Server 7.0.
- After Window NT restarts, clear the Show this Welcome Screen next
time you start Windows NT check box, and then click Close.
- Insert the SQL Server 7.0 compact disc into the CD-ROM drive.
- When the Microsoft SQL Server dialog box appears, click Install SQL Server
7.0 Prerequisites.
- Click Windows NT 4.0.
- Click Minimal Install.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| License agreement |
Accept
|
| Active channel selection |
None
|
| Destination folder |
Default path
|
Click No to All when prompted to overwrite the newer file.
Click OK to finish the installation.
Click OK to restart Windows NT.
To install and configure Microsoft Windows NT 4.0 Option Pack
In this procedure, you will install Microsoft Windows NT 4.0 Option Pack. This is
required for classroom labs.
- After Windows NT restarts, insert the Windows NT 4.0 Option Pack compact disk into
the CD-ROM drive.
- Using Windows Explorer, open the Ntoptpak\En\X86\Winnt.srv folder, and double-click Setup.
- When prompted, supply the following configuration information.
| For this installation option |
Use this information
|
|
| License agreement |
Accept
|
| Upgrade |
Upgrade Plus
|
| Select components |
Front Page 98 Extensions and its defaults
Internet Information Server (IIS) and its defaults
Microsoft Data Access Components 1.5 and
its defaults
Microsoft Management Console
Windows NT Option Pack Common Files
Transaction Server and all subcomponents
|
| MTS destination folder |
Default path
|
| Administration account |
Local
|
Click Finish to finish the installation.
After Microsoft Windows NT 4.0 Option Pack has been installed, click Yes to
restart the computer.
To install and configure Windows NT SP4
In this procedure, you will apply Windows NT SP4.
- 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.
- In the command prompt dialog box, press any key to apply
Windows NT 4.0 SP4.
This is the 40-bit version of SP4. If you have installed the 128-bit version of
Windows NT 4.0 Server, cancel the batch file when it is ready to install the service
pack, and install the 128-bit version of the service pack.
Windows NT will restart after SP4 has been applied.
-
- To install and configure Microsoft SQL Server 7.0
In this procedure, you will install Microsoft SQL Server 7.0
- After Windows NT restarts, insert the SQL Server 7.0 compact disc into the CD-ROM
drive.
- When the Microsoft SQL Server dialog box appears, click Install SQL Server
7.0 Components.
- Click Database Server Standard Edition.
- 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 |
studentx
|
| Company |
Your company name
|
| Setup type |
Custom (select all components)
|
| Destination folder |
Default path
|
| Components and sub-components |
Select all components and sub-components
|
| Character set (Use default) |
ISO Character Set
|
| Sort order (Use default) |
Dictionary order, case-insensitive
|
| Unicode collation (Use defaults) |
General Unicode, case-insensitive,
width-insensitive, Kana-insensitive
|
| Network libraries ( Use defaults) |
Named Pipes (use default pipe)
TCP/IP Sockets (use default port)
Multiprotocol
|
| Service Settings |
Domain user account
|
| User name |
Administrator
|
| Password |
pass1502
|
| License Mode |
Per Seat
|
- After SQL Server has been installed, click Finish.
-
- To install and configure Microsoft SQL Server 7.0 OLAP Services
In this procedure, you will install Microsoft SQL Server 7.0 OLAP Services.
- Click SQL Server 7.0 OLAP Services.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Accept the License Agreement |
Yes
|
| CD key |
111-1111111
|
| Services destination folder |
Default path
|
| Data destination folder |
Default path
|
| Select Components |
All components
|
| Program folder |
Default folder
|
- Click Yes to overwrite the read only file.
- After OLAP Services setup completes successfully, click OK.
- After OLAP Services has been installed, click No, I will restart my computer later,
and then click OK.
-
- To install and configure Microsoft English Query
In this procedure, you will install Microsoft English Query.
- Click English Query.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Destination folder |
Default path
|
| License agreement |
Agree
|
| Setup type |
Complete
|
- After English Query setup is completed successfully, click OK.
- Click Exit to close the SQL Server 7.0 Install SQL Server 7.0 dialog
box.
-
- To install and configure Office 2000 components
In this procedure, you will install and configure Office 2000 components
- Insert the Office 2000 Beta 2, CD 1 compact disc into the CD-ROM drive.
- Use the information in the following table to complete the installation.
| For this installation option |
Use this information
|
|
| Customer information |
Default information
|
| Setup options |
Customize
|
| Installation location |
Default path
|
| Internet Explorer 5.0 |
Standard installation
|
(continued)
| For this installation option |
Use this information
|
|
| Components to Install |
Make sure that the installation options for the following components are
set to Run from My Computer:
Microsoft Excel
Microsoft Access
MS Query (Under Office Tools)
Do not install Microsoft Word for Windows, Microsoft PowerPoint for Windows, Microsoft
Outlook for Windows, or Microsoft Front page for Windows.
|
- Click Yes to restart the computer.
-
- To complete the installation of the student computer
In this procedure, you will finish the installation of Office 2000 components, change
the administrator password and reconfigure the SQL Server service logon account
password.
- After Windows NT restarts, and after Office 2000 and Internet Explorer 5.0 complete
their installation, open User Manager for Domains.
- Change the password of the Administrator account to password.
- Close User Manager for Domains.
- Open Control Panel, and then double-click Services.
- Click MSSQLServer, and then click Startup.
- In the Password box, type password.
- In the Confirm Password box, type password, and then click OK.
- Stop and restart the MSSQLServer service.
- Close Services.
-
- To configure the desktop area
In this procedure, you will configure the desktop area for 800 x 600 pixels.
- In Control Panel, double-click Display, and then click Settings.
- Set the desktop area to 800 x 600 pixels.
- Click Test, and then click OK.
- Click Yes if you saw the test bitmap properly.
- Click OK to close the Display Properties dialog box.
Log off of Windows NT.
The student computer is ready for class.
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 for the setup of the
classroom, including Windows NT 4.0 SP3 and SP4, Microsoft PowerPoint Viewer, Microsoft
Viewer for Word, and additional fonts.
- SG_1502a.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
- On the Programs menu, click Microsoft PowerPoint Viewer.
- After PowerPoint Viewer starts, in the Look in box, select your drive C.
- In the Directories box, click PowerPnt.
- In the File name box, click the appropriate PowerPoint file, and then
click Show.
|