This instruction describes installation of SQL Server and the Facilia Parameter Database components on your computer.

The Facilia Parameter Database software package includes the following components:

• The Facilia DB and Facilia DB Administration client applications – standalone database manager tools.
• A script to set up an empty parameter database on Microsoft SQL Server; therefore, prior installation of the server is required (see Step 1).

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, you can verify the presence of SQL Server on your computer following the steps indicated here List instances of SQL Server installed. If any instance is listed there - skip Step 1.

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

1.1) Download the setup.exe file for the installation of SQL Server Express from Microsoft official website. Make sure to select the free Express edition of SQL Server at this page:

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

1.2) Launch installation.

Install SQL Server Express using the Installation Wizard GUI launched from the setup.exe file.

Windows might ask you to install additional software components or service packs before installation of SQL Server will be possible

Note that almost all the settings during installation should be left in their default state. Exception is that it is recommended to install SQL Server as “default instance”. You might need to change this setting from its default state (see screendump in the file above). If you have selected to install it as named instance - refer to the section Advanced when performing Step 3 and Step 4.

1.3) Restart your computer

Download and installation:

2.1) For customers who have purchased the AFRY Intelligent Scenario Modelling Parameter database toolbox, contact AFRY Intelligent Scenario Modelling support (intelligentscenariomodelling@afry.com) to receive the download link for the “Facilia DB” setup file.

2.2) To install the “Facilia DB” software package, run the setup file and follow the on-screen instructions. Once the installation is complete, you will have access to all the components of “Facilia DB”:

• a script to create a parameter database on Microsoft SQL Server. This is explained in Step 3.
• two standalone database manager tools: the Facilia DB and Facilia DB Administration client applications. Through the Facilia DB client users can view, add or edit the parameter data.

3.1) After finishing of installation of “Facilia DB” software - find a sub-folder utilities in the software installation folder, typically C:\Program Files\Facilia DB 8.5\utilities

3.2) Copy folder utilities to your desktop

3.3) There is a file inst.bat in the folder utilities. If you like to change default installation settings - you need to edit this file as described in the section Advanced below. Otherwise perform instructions described in the item 6

3.4) Run file inst.bat located in the folder utilities by double-clicking on the file name in Windows Explorer. Database will be created. 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 also to use information provided in Advanced section below.

Database will have the name facilia_db_template and will be installed to the default instance of SQL Server located on the local computer using Windows Authentication. By editing file inst.bat you can install database with another name, use named instance of SQL Server located on the sever or local computer, use SQL Server Authentication instead of Windows Authentication. Inst.bat contains comments which will help you.

Read more here Installing the Parameter Database - Advanced topics

4.1) Open SQL Server 2022 Configuration Manager. If you're unsure of the version, you can search for “SQL Server Configuration Manager” in the Windows Start menu.

4.2) In Configuration Manager - select SQL Server Network Configuration.

4.3) Double click on the Protocols for <instance_name>. In the case if only one SQL server is installed on your computer - the list will contain only one line, e.g. Protocols for SQLEXPRESS

4.4) Double click on TCP/IP

4.5) In the dialog which will appear - set Enabled to Yes (or verify that it is in Yes state) and click OK

Read more here Installing the Parameter Database - Advanced topics

If you have installed SQL Server as named instance - follow the additional instructions

5.1) Run Facilia DB Administration tool.

5.2) To log in, enter the Name user and the Password fdb. This is the default user (administrator) in freshly installed parameter database

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

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

5.5) Assign newly created user to the role of administrator of this project using the table 'Roles' in the main view.

5.6) Exit Facilia DB Administration tool.

Back