The SQL Express server installation

Before you can begin to use the SQL functionality in IGSS, an SQL server must first be installed. Either a full SQL server or the Microsoft runtime SQL Express server may be used.

The steps below describe the installation and configuration process for the SQL Express software. You are free to install this SQL server on any PC in the network or on the IGSS server PC.

If you haven’t already installed the SQL Express software when initially installing the IGSS software, you must do so now. Place the IGSS CD in the drive and find the sub-folder called [CD drive:]\IGSS Demo\SQLexpress and click the SQLEXPR.EXE program found here and follow the on screen instructions. After this installation has been successful, you must then install the server management software package. (See below.)

SQL Express

The following illustrations are in chronological order and show the most important steps in installing the SQL Express  software.

SQL Express: installation of Prerequisites

 

SQL Express Wizard

 

The 13 items tested before actual installation of SQL Express

 

The user registration information dialog box

 

Selecting features to install

 

Settings to select for Service Account

 

The authentication mode choices

 

The actual installation is initiated from here

 

The installation process is nearly completed

 

After a few more screens, the SQL Express installation is complete. Go to the next topic to see how to install the SQL server management software tools.

 

Server management software installation

The management software installation you select to install depends on the size of the PC's  processor. If you're installing on a 64-bit system, then you must run the SQLServer2005_SSMSEE_x64.msi software. If you're installing on a 32-bit system, then you must run the SQLServer2005_SSMSEE.msi software.

The illustration below is the first screen that appears with the 32-bit installation. Click Next and follow the on screen instructions.

 

The introduction screen for installing the SQL management software

When finished, you must then select settings as described in the next topic.

Settings in the SQL Server

After successfully installing both pieces of software, the programs are accessed from Start - All Programs - Microsoft SQL Server 2005 - Configuration Tools and Start - All Programs - SQL Server Management Studio Express.

Follow the steps below to configure the SQL server.

  1. Go  Start - All Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager
  2. In the tree view select SQL Server 2005 Services and then double click the first icon on the right, SQL Server (SQLEXPRESS).to bring up the SQL Server (SQLEXPRESS) Properties dialog box.
  3. Select the tab Service and make sure the Start Mode is set to Automatic by clicking on the drop down box to the right.
  4. Click OK to save and exit, and then right click the SQL Server (SQLEXPRESS) icon to make sure it's running.
  5. Next, click the SQL Server 2005 Network Configuration in the tree view followed by a click on the Protocols for SQLEXPRESS.
  6. On the right, click on Shared Memory to enable it (icon changes to yellow) and TCP/IP to enable it (icon changes to yellow).
  7. Click the red close X-button  to save and exit.

Follow the steps below to configure the SQL Server Management Studio Express. For Windows XP you must be logged on as a user with administrative rights and on Windows Vista you select Run as administrator.

  1. Go Start - All Programs - SQL Server Management Studio Express and the Connect to Server dialog box appears.
  2. In the Authentication: drop down box select the authentication scheme to use and click Connect.
  3. The Microsoft SQL Server Management Studio Express dialog box opens and in the tree view, select Security.
  4. Right click and select New - Login...and in the Login name: field select the NT user (group) that is to have administrative rights to the database server; and remember to select Windows authentication.
  5. In the tree view select Server Roles and make sure to select all choices displayed in the window at the right.
  6. Exit the program.

 

The IGSS databases must now be prepared to work with SQL Express.

 

To continue by creating an SQL database for HDM data, click here.

To continue by creating an SQL database for Maintenance data, click here.

To continue by creating an SQL database for log data, click here.