======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|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|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 [[https://www.microsoft.com/en-us/download/details.aspx?id=53591|command-line tools]]

=====Step 2 - Install User interface and Administration tool for Facilia Parameter database=====
  - Download installation file using the link you will receive from our support.
  - 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|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 - Advanced topics|Installing the Parameter Database - Advanced topics]]