1131a

alt="nt.gif (1423 bytes)" border="0" WIDTH="128" HEIGHT="12">

SQL 7.0 Upgrade and Migration (1131) 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.

Hardware

The following hardware is required for the instructor computer:

Pentium 166

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 (40-bit version) with 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)

Microsoft SQL Server™ version 6.5 with SP4 (SP4 is 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)

Student Computer

Each student computer requires the following hardware and software.

Hardware

The following hardware is required for each student computer:

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

Windows NT Server version 4.0 (40-bit version) with SP4
SQL Server 7.0
SQL Server 6.5 with SP4
Internet Explorer 4.01 SP1

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 SQL Server sa account on the instructor computer is pass1131.

The classroom setup script assumes that the Windows NT domain name is domain1131 and the instructor computer name is instructor1131. If the names are different, follow the instructions in this setup guide to edit files to reflect the correct domain and computer names.

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 SQL Server 6.5.

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

Set up the hardware according to the manufacturer’s instructions. (Refer to the hardware requirements.)
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 FAT
50 MB of unformatted space

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 (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		instructor1131 (default computer name)
Server type		Primary domain controller
Administrator account password		pass1131

(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
Additional network services		Microsoft DHCP Service 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)		Your domain name
DNS Service search order		The TCP/IP address for the DNS server in your domain
Primary WINS server (WINS Address tab)		192.168.1.200 (default IP address)
Bindings		Defaults
Windows NT domain		domain1131 (default domain name)
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 AVI files.

After Windows NT restarts, log on with a user name of Administrator and a password of pass1131.
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 Don’t 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.

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 new 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 close the IP Address Array Editor dialog box.

Click OK to close the DHCP Options: Scope dialog box.

Click OK to close the DHCP Manager message box.

Exit DHCP Manager.

To execute 1131_Ins.cmd

In this procedure, you will execute the 1131_Ins batch file. This batch file will apply Windows NT 4.0 SP4, and it will copy software to drive C. It will also install 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.
In the root directory, double-click 1131_Ins and follow the instructions on the screen.

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.

After SP4 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 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 configure domain user accounts and install Windows NT Media Player

In this procedure, you will execute a batch file that installs the Windows NT Media Player and adds student and administrative user accounts to Windows NT. You will then change the password never expires attribute
of all user accounts.

The script you are about to run assumes that your Windows NT domain name is domain1131. If it is not, edit and save the Management.csv and Admin.csv files in the C:\Setup folder before you continue.

After Windows NT restarts, click the Start button, and then click Run.

In the Open box, type C:\Setup\Users_i and then click OK.

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.

Select all of the users in the Username list.

On the User menu, click Properties.

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

Clear the User Must Change Password at Next Logon check box.

Click OK.

Close User Manager for Domains.

To install and configure SQL Server 6.5

In this procedure you will install SQL Server 6.5. This is needed for the upgrade module.

Insert the SQL Server 6.5 compact disc into the CD-ROM drive.

Using Microsoft WindowsŽ Explorer, open the i386 directory on the
CD-ROM drive and double-click Setup.exe.

Use the information in the following table to complete the installation of SQL Server 6.5.

For this installation option	Use this information

Name	administrator
Company	Your organization name
Product ID	SQL65SP4
Microsoft SQL Server 6.5 - Options	Install SQL Server and utilities
Choose Licensing Mode	Per server
Concurrent Connections	50
SQL Server Installation Path	C:\Mssql
Master Device Creation	Defaults
SQL Server Books Online	Install on hard disk
Installation Options	Defaults
SQL Server Executive Log On Account	Install to log on as Local System account

After SQL Server 6.5 has been installed, click Exit to Windows NT.

To install SQL Server 6.5 SP4

In this procedure, you will install SQL Server 6.5 SP4. This is required in order to upgrade from SQL Server 6.5 to SQL Server 7.0.

Insert the SQL Server 7.0 compact disc into the CD-ROM drive.
Using Windows Explorer, open the 65SP4\i386 directory on the CD-ROM drive and double-click Setup.exe.
When requested to supply the SA password, leave the password boxes blank. The default SA password is blank.
After SQL Server 6.5 SP4 has been installed, click Exit to Windows NT.

To install the Credit database

In this procedure, you will install the credit database in SQL Server 6.5. This database is used for the upgrade module.

Click the Start button, point to Programs, point to Microsoft SQL Server 6.5 and then click SQL Server Manager.
Double-click Start/Continue to start the MSSQLServer service.
Click the Start button, and then click Run.
In the Open box, type C:\Credit\Credit and then click OK.
After the credit database has been successfully installed, close the CASESTUD.LOG text file.
Double-click Stop to stop the MSSQLServer service.
Close SQL Service Manager.

To install and configure SQL Server 7.0

In this procedure, you will install SQL Server 7.0.

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
SQL Server Upgrade wizard	Do not run the SQL Server Upgrade wizard
Setup Type	Custom
Destination folder	Default path
Components and sub-components	Add Full-Text Search and accept all other defaults

(continued)

For this installation option	Use this information

Character set	ISO character set
Sort order	Dictionary order, case-insensitive
Unicode collation	General Unicode, case-insensitive, width-insensitive, Kana-insensitive
Network libraries	Named Pipes TCP/IP Sockets Multiprotocol
Services accounts	Same account for all services Auto start SQL Server service
Service settings	Domain user account
User name	SQLService
Password	sqlservice
Domain	domain1131 (default domain name)
Licensing mode	Per server
Number of licenses	50

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

To configure SQL Server Agent

In this procedure, you will configure SQL Server Agent to start automatically. This is required for instructor demonstrations.

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.
Click the Start button, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager.
Expand Microsoft SQL Servers, expand SQL Server Group, and then expand Instructor1131.
Right-click Instructor1131, and then click Properties.
Select the Autostart SQL Server Agent check box, and then click OK.
Expand Management.
Right-click SQL Server Agent, and then click Start.

To set the SQL Server sa account password

In this procedure, you will configure the SQL Server sa account password. This is good administrative practice, and secures the instructor computer.

Expand Security, and then click Logins.
In the details pane, double-click sa.
In the Password box, type pass1131 and then click OK.
In the Confirm New Password box, type pass1131 and then click OK.
Close SQL Server Enterprise Manager.

To configure the display settings

In this procedure, you will configure your display settings for 256 colors.

In Control Panel, double-click Display.
Click Settings.
Verify the Color Palette setting is set to 256 colors.
If it is not, click Display Type, and then click Change.
Install the drivers for your video card.
If requested, restart Windows NT and when Windows NT restarts, log on as Administrator and configure the new video driver for 256 colors.
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

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 (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
Network services		Defaults
DHCP		Yes
Bindings		Defaults
Make this computer a member of		domain1131 (default domain name)

(continued)

For this installation option	Use this information

Create a computer account in the domain		Yes
User name		Administrator
Password		pass1131
Time zone		Your time zone.
Display properties		Your display settings (800 x 600 is recommended)

To execute 1131_Std.cmd

In this procedure, you will execute the 1131_Std.cmd batch file. This batch file will apply Windows NT 4.0 SP4, 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 that you are about to execute assumes that the name of the instructor computer is instructor1131. If it is not, edit and save the 1131_Std.cmd file in the C:\Setup folder on the instructor computer before you continue.

After Windows NT restarts, log on to domain1131 with a user name of Administrator and a password of pass1131.

Click the Start button, and then click Run.

In the Open box, type \\Instructor1131\Setup\1131_Std and then click OK. Follow the instructions on the screen.

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

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.

After Service Pack 4 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 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 SQL Server 6.5

In this procedure you will install SQL Server 6.5. This is needed for the upgrade module.

After Windows NT restarts, insert the SQL Server 6.5 compact disc into the CD-ROM drive.

Using Windows Explorer, open the i386 directory on the CD-ROM drive, and double-click Setup.exe.

Use the information in the following table to complete the installation of SQL Server 6.5.

For this installation option	Use this information

Name	studentx
Company	Your organization name
Product ID	SQL65SP4
Microsoft SQL Server 6.5 - Options	Install SQL Server and utilities
Choose Licensing Mode	Per server
Concurrent Connections	50
SQL Server Installation Path	Default path
Master Device Creation	Default options
SQL Server Books Online	Install on hard disk
Installation Options	Default options
SQL Server Executive Log On Account	Install to log on as Local System account

After SQL Server 6.5 has been installed, click Exit to Windows NT.

To install SQL Server 6.5 SP4

In this procedure, you will install SQL Server 6.5 SP4. This is required in order to upgrade from SQL Server 6.5 to SQL Server 7.0.

Insert the SQL Server 7.0 compact disc into the CD-ROM drive.
Using Windows Explorer, open the 65SP4\i386 directory on the CD-ROM drive, and double-click Setup.exe.
When requested to enter and confirm the SA password, leave the password boxes blank. The default SA password is blank.
After SQL Server 6.5 SP4 has been installed, click Exit to Windows NT.

To install the credit database

In this procedure, you will install the credit database in SQL Server 6.5. This database is used for the upgrade module.

Click the Start button, point to Programs, point to Microsoft SQL Server 6.5 and then click SQL Service Manager.
Double-click Start/Continue to start the MSSQL Server service.
Click the Start button, and then click Run.
In the Open box, type C:\Credit\Credit and then click OK.
After the credit database has been successfully installed, close the CASESTUD.LOG text file.

To configure the desktop area

In this procedure, you will configure the desktop area for 800 x 600 pixels.

Open 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.
Shut down and restart Windows NT.

The student computer is now ready for class.

Trainer Materials Compact Disc Contents

The Trainer Materials compact disc contain 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.

1131_Ins.cmd. This batch file is used to assist in the setup of the
instructor computer.

MOCAutoInstall. This folder contains files that are used to for the setup of the classroom, including Windows NT 4.0 SP4, Microsoft PowerPoint Viewer, Microsoft Viewer for Word, and additional fonts.

Readme.txt. This file contains a description of the compact disc contents and setup instructions, saved in ASCII format (non-Word document).

SG_1131.doc. This file contains a description of classroom requirements, configuration, and 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 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, click your drive C.

In the Directories box, click PowerPnt.

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

Š F1 Computing Systems 2001