User Tools

Site Tools


installing_the_parameter_database_updated

Installing the parameter database updated

This instruction describes installation of SQL Server Express and Parameter database on your computer.

If you want to install Parameter database on the server of your organisation to share access to database - see instruction Installing on the Server of Organisation.

Instructions below assume that you don’t have any instances of the SQL Server installed which is usual situation for the end-user computer. If you are not sure, for example, if you have on the computer some software which might install SQL Server, then presence of SQL Server can be verified as shown here List instances of SQL Server installed. If any instance is listed there - skip Sep 1

Step 1 - Install SQL Server Express

The latest version of the SQL Server Express (SQL Server 2019 Express Edition) can be found at https://www.microsoft.com/en-us/sql-server/sql-server-downloads

  • Download and launch installation for SQL Server Express Edition

Warning! You might be asked to install additional software components or service packs before installation of SQL Server will be possible

  • Select “Basic” installation. Basic installation will require minimal interaction from your side during the installation process.
  • Download and install command-line tools for SQL Server command-line tools

Step 2 - Install User interface and Administration tool for Facilia Parameter database

  1. Download installation file using the link you will receive from our support.
  2. Run installation file and follow instruction.

Step 3 - Create empty database facilia_db_template

1. After finishing of software installation in the previous step - find a sub-folder utilities in the Parameter Database software folder, typically C:\Program Files (x86)\Facilia DB\utilities
2. Copy folder utilities to your desktop

Warning! If you have skipped Step 1, then you might need to edit a file inst.bat located in the folder utilities. This also required if you like to change default installation settings. Details are described in the section Advanced

3. Run file inst.bat located in the folder utilities by double-clicking on the file name in Windows Explorer. The process of database creation may takes several minutes. In the case of success you will get message “Database has been created”

In the case of errors you will get the message “Error! Check file log.txt”. Open file log.txt located in the same directory to review details about error. In the case of errors you might need to edit inst.bat as described in the Advanced section below.

Step 4 - Start database tools first time, setup connection

Run Facilia DB Administration tool.

Setup connection parameters and test connection to the server as described in the Starting the Parameter database

Step 5 - Create first project for your database

Run Facilia DB Administration tool.

Enter user in the Name fileld and fdb in the Password field in the login screen of the tool.

Warning! If you have edited the inst.bat you will need also to change the connection settings of the Facilia DB Administration Tool

Create new user account (using button Create user on the toolbar).

Create new project (using button Create project on the toolbar).

Assign newly created user to the role of administrator of this project (using table Roles).

Exit Facilia DB Administration tool.

In the case of problems during the steps above - these materials will help you:

installing_the_parameter_database_updated.txt · Last modified: 2023/01/20 17:03 by ecoloco