Fast Track to SQL Setup Guide

Advanced ColdFusion MX Development 600 Setup Guide

This document outlines the hardware, software and equipment requirements necessary for configuring and using Fast Track to SQL 200. Refer to this document before you attempt any setup.

Setup Overview

Wizards drive installation and configuration procedures for all of the applications that you need to install. A high-level view of the required components for installation for this course is:

Web browser – Microsoft Internet Explorer 5 or better
Macromedia ColdFusion MX Server Developer Edition or higher
Student files executable located on the CD

Prior to installation, you will need to obtain the software applications required to run the course files. Depending on whether you're a student, instructor, training center, or partner, you can obtain the software in one of two ways:

Evaluation Software – You can obtain software applications that will last for 30 days before expiring from Macromedia's product download page,
Licensed Software – If you are a student, you can install your licensed copy of the software on your machine. If you are a training center or partner, follow the guidelines established by the MATP for acquiring software.

The evaluation version of ColdFusion MX Server Enterprise Edition will turn into the Developer Edition after 30 days.

This section describes how to set up and configure each computer for the Fast Track to SQL 200 course. Set up the computers at least one day prior to the start of the course so that the instructor may load additional software and review the machine configuration before the class starts.

Network Requirements

All classroom machines must be networked together.
The instructor needs read, write and execute access to one shared directory on a central machine, preferably the instructor machine. All student PC's should have access to this shared directory.
Macromedia also strongly suggests that each classroom machine have Internet access.
All software needs to be installed under the local administrator account, not a copy or one set up to be an admin account, nor a domain admin account if they are part of a domain.

Course Assets

Place a copy of the Fast Track to SQL student guide at each student station before class.

Audio/Visual

The classroom must have the following available at the front of the room:

Projection screen
Projection unit capable of 800x600 (or higher) resolution cabled to instructor’s PC
Flip chart on easel or side whiteboard for instructor notes

The classroom should include one PC for each student and one PC for the instructor. Each machine must meet these minimum requirements:

System Requirements

Windows

Intel Pentium II processor or faster
Windows 2000, NT, or XP
256 MB RAM (512 MB recommended)
675 MB hard disk space
Internet Explorer or Netscape Navigator 4.0 or higher
CD-ROM drive and access to a floppy drive
Color monitor with 800 x 600 resolution, 256 colors (1024 x 768 resolution, millions of colors recommended)

All classroom PCs must have the following applications installed and configured in this order.

One of the following Web browsers:

Microsoft Internet Explorer 5.0 or higher

ColdFusion MX Developer Edition or higher for Windows. During the installation process:

Use the standalone server when prompted for web server
Use “admin” when prompted for a password (you will change this later)
Install the example applications and documentation

A copy of Microsoft SQL Server 2000 Desktop Edition (MSDE 2000) This is available as a free download from Macromedia instructor central.
WinZip software
The latest Flash player

Testing the

Installation

In order to determine that your applications are installed and working correct, follow the steps in each of the following sections.

ColdFusion MX Server Test

After the ColdFusion MX server software is installed, test the install to ensure that each machine recognizes the ColdFusion MX Application Server.

Type the following URL into the browser location bar to test the ColdFusion MX Application Server installation:

index.htm

Note: If the ColdFusion MX Administrator prompts you for a password, the software has been properly installed.

Post-installation

Here are additional setup steps that need to be completed by either a site administrator or the course instructor.

Security for the ColdFusion MX Administrator and RDS should be turned off

To verify, click Start  Programs  Macromedia ColdFusion MX  Administrator.
Enter the password that you provided when you installed ColdFusion MX (admin) and click the Login button.
Under SECURITY, click the CF Admin Password link.
Remove the check from the Use a ColdFusion Administration Password checkbox and click the Submit Changes button.
Under the SECURITY, click the RDS Password link.
Remove the check from the Use an RDS password for Dreamweaver MX or ColdFusion Studio checkbox and click the Submit Changes button.

ColdFusion MX debug information should be turned off

While still in the ColdFusion MX Administrator under DEBUGGING & LOGGING, click the Debugging Settings link.
Make sure that the Enable Debugging checkbox is not checked. If it is checked, uncheck it and click the Submit Changes button.

Course Files Installation

Place the Student CD into the CD tray.
Go to Start  Run… and type D:\ftsql200_setup_0802.exe where “D” is the letter of your CD-ROM drive. Press OK.
Click Unzip.
Click OK, and then Close.
Verify that C:\CFusionMX\wwwroot\mmcourses\ftsql200\ installed correctly by locating the directory in Windows Explorer.

Configure the Course Files

Numerous datasources, mappings, etc. need to be configured. The simplest way to do this is browse the page at the following URL:

Test the Course Files Installation

Open up a browser and type in the following URL:

Note: If you see the Fig Leaf SQL Tool, the course files were properly installed in the correct directory.

05/13/191