Creating the LOG database on the SQL server

Before following the steps below, you should have installed the SQL Express  database as described in the topic SQL Express server installation.

  1. Go Start - All Programs - Microsoft SQL Server 2005 - SQL Server Management Studio Express and click Connect.
  2. In the tree view select right click on the folder Databases - New databases... and the New Database dialog box appears.
  3. In Database name: key in LOG and click OK.
  4. The database is created and the name LOG appears in the Databases list in the  right window.
  5. Go File - Open - File...and the folder SQL in the IGSS installation should open as default. If not, then browse to it in the path [IGSS installation]\7T\IGSS32\V7.0\SQL Select the file called logdb.sql and click Open.
  6. The SQL Server 2005 now opens; click Connect and the content of the logdb.sql file is displayed.
  7. Activate Ctrl-A to select the entire content and then press the F5 key to run the sql script.
  8. Under the Messages tab that appears after script execution a message should appear: Command(s) completed successfully as well as a message at the bottom of the dialog box Query executed successfully.
  9. Exit the program.

To continue with the next procedure, click here.