Version User Scope of changes
Jan 19 2011, 10:16 AM EST (current) sdrevik 41 words added
Oct 7 2009, 5:14 PM EDT sdrevik 15 words added

Changes

Key:  Additions   Deletions
Before AirVision can be installed, SQL Server or SQL Express and .NET Framework version 3.5 must be installed on your computer. SQL will request that theWindows Component Internet Information Services (IIS) be added, but IIS is NOT necessary for AirVision and does not have to be enabled. IIS is only used for SQL Reporting Services, which AirVision does not require or utilize.


Installing Microsoft .NET Framework

If you don’t already have .NET Framework installed on your computer, you can download it from the Microsoft website. Follow the instructions in the installation wizard.


Installing SQL Server
Before SQL Server can be installed, .NET Framework version 3.5 must be installed.

>> Important! Although AirVision will operate with either SQL Server or SQL Express, you should know that SQL Express has a file size limit of 4G, so if you convert files from E-DAS Ambient to AirVision (i.e., SQL files) you will run out of room quickly in SQL Express, especially if you are converting and collecting minute data. Agilaire STRONGLY recommends that, even though SQL Express is a free download, it will be easier on you as an AirVision user to start with the full version of SQL Server 2005 or 2008 rather than have to later go through all the steps of upgrading to the full version of SQL Server from SQL Express. later, because SQL Express will stop functioning when it has reached its capacity of 4G.
To install SQL Server (or SQL Express AFTER reading the Important warning above), insert the CD or DVD and follow the instructions in the wizard. In the first screen check the box to accept the license agreement and click Next.

The default features are sufficient in the Feature Selection screen, but you can select the program features you want installed. The most important feature to install is Client Tools. Click Next.

Agilaire recommends Windows Authentication Mode if the SQL server and the AirVision application is on the same PC. Otherwise, select SQL Authentication and provide the appropriate username / password from the SQL server administrator. Note that this account must have read, write, update, and execute permissions. The purpose of Authentication Mode is to specify the security used when connecting to SQL Server.

If you select Windows Authentication Mode a password is not required (Figure 1-3).

If you select Mixed Mode (Windows Authentication and SQL Server Authentication) you must enter and confirm a password for the System Administrator (logon user name “sa”). Click Next to continue.

The remaining setup screens are self-explanatory. Follow the directions and click Finish in the Completing Microsoft SQL Server 2005 Setup screen .

>>Note: If you set up SQL in Windows Authentication mode, you must must log in to SQL with Windows Authentication, not SQL Server Authentication, or the AirVision Service won’t start.


Installing The Database

After you have installed SQL Server:

  1. From the Windows Start menu, select All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
  2. Right-click the Databases folder and select New Database. For the Database name, enter AVData and click OK.
  3. Click to select the database you just created (AVData)
  4. Open the installation file Installer\program files\Agilaire LLC\AirVision\Database and double- click AVReleaseCreator.sql. The script should open in AVData.
  5. Click ! Execute to run the query. The query will install the SQL tables needed to run AirVision.