Executable installation
 The Status program is installed by running the installation program
StatusSetup.exe This program will install the program and all the associated DLL files required to run the program. When the program is used for the first
time, it will open the SQL server connection window. The Provider is normally SQLOLEDB. The Source is the name of the SQL server to which the
program must connect to access the database. It is normally the PC name or IP address followed by the server name.
In a domain environment Windows Authentication will be the better method to connect to the SQL server. In a Peer-to-peer network, this option is not
available and each user name and password must be provided to log in to the server.
Once all the parameters are entered, select Open to connect to the server. The next step is to select the Database on the server.
Find the SQL Server
On a new server installation, it might help to verify that the server is running and what is the name of the server instance. Open the
SQL Server configuration manager from the main Windows menu under Microsoft SQL Server | Configuration tools. The first window
shows the server and the server status when the SQL Server Services option is selected. Make sure that the server is "Running"
The second window shows the instance name of the server when the Aliases option is selected. This must be used in the Source field above before you will be able to connect.
First time installation
Users will require the following files:
- StatusSetup.exe This file must be installed first, but users should only run this program if a SQL database has been pre compiled
and supplied for the installation. If this is not the case, as new database must be created and populated
- Avdatadb2SQL.exe This file will install the file db2SQL in the same program directory as the Status program described above. A
menu link will be created to the program. db2Sql will assist the users to create an empty database and populate the database
with dBase data for existing users. Note: It is important that the first time installation is done on the server PC to ensure that the files are installed on the same PC where the SQL server is running.
Once installed, select from the Start menu the Convert menu option. From this program select the File | Connect option first which will
show the SQL Server connection window as shown above. Connect to the server with a poweruser and proceed to connect to the catalog (database)  First time installation of the status program requires the database adbStatus to be created or attached to the
SQL server. Installation of SQL Server 2008 is assumed to be in place and you must have a user that has permission to alter databases in the server. The installation will under normal situations
set everything to all the Status program to attach the database.
The choice of the directory for this data file is important. Once attached to the server, it will remain
in this directory where it will be accessed by the SQL server. The file must therefore be installed on
the same PC as the server to reduce network traffic. The installation directory must also be in a position where it will be included in the normal server backup. The default file path is
c:\ProgramData\Avdata\SQL
Install this file from the PC where the first Status will be installed. This must be done a a registry entry is created in the registry that will assist the program to know where the data file is when it is
attached to the server. Once connection is established to the server, users will be prompted to connect to the Database or Catalog.
If the adbStatus database is not attached in th the SQL server, the Create button will be available, which will allow users to attach the database to the server or create a new empty database.
 Connecting to the data
Once the data is attached to the server, users will be prompted to connect to the adbStatus data and the Create button will not be available. Select the adbStatus option followed by the Save
button. The SQL server connection information will now be saved for future logins to the program.
If you have sufficient rights to set user permissions to the database, the Manage Access button will now be available.
Setting User rights
 By selecting the Manage Access option on the SQL
Connection window, users can manage the access of other users to the data base. The first option Grant can be used where users log on with Windows Authentication. This
option will give "db_owner" role to all users in the "BUILTIN\Users" group.
The second button, Assign, will create a users with the password provided if the name does not exist and then assign the "db_owner" role to this user.
The table on the left shows all the allowed access for the current user.
Data files
Once all these steps are complete, users will have empty database or if a database was supplied your dBase data will be available.
If you are starting with an empty database and require to upgrade from a previous dBase installation, you will have to
populate the data. This is also done from the db2SQl conversion program by selecting the menu option File | Convert dBase to SQL
When upgrading from a dBase file structure, it is important to ensure that the dBase Status data is up to date and contains all the
latest file structure updates. On this window select Status, Load Database, SQL, Populate in this sequence to create the file structures and populate the files.
Procedures
SQL procedures must be loaded in the new empty database structure. This is done from the menu option File | Stored Procedures. Again select Status, Open Catalog and Import. These procedures are loaded from the file adbDataBuild,mdb that should be in the default directory: c:\ProgramData\Setup
Status SQL
This completes the SQL database compilation and population. The next step is to open the StatusSQL program and start working. You will have to register the program on line to validate the installation and assign the license key. Your user ID number and password must be provided by Aviation Databases to complete this step.
Step by Step instructions
Click here to get a list of step by step instructions.
|
