This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
installing_the_parameter_database [2023/02/23 10:43] boris [Step 3 - Creating parameter database on SQL server] |
installing_the_parameter_database [2023/03/02 13:58] boris [Step 2 - Installing "Facilia DB" software package on your computer] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Installing the Parameter Database ====== | ====== Installing the Parameter Database ====== | ||
- | This instruction describes installation of SQL Server and Parameter database on your computer. 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|Installing on the Server of Organisation]] | + | This instruction describes installation of SQL Server and Parameter database |
+ | |||
+ | This Facilia Parameter Database software includes two components, a relational database built on Microsoft SQLServer and the **Facilia DB** tool. | ||
+ | |||
+ | 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|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|Installing on the Server of Organisation]] | ||
===== Step 1 - Installing SQL Server Express ===== | ===== Step 1 - Installing SQL Server Express ===== | ||
Line 15: | Line 21: | ||
//Windows might ask you to install additional software components or service packs before installation of SQL Server will be possible// | //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 2 and Step 3. | + | 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 | 1.3) Restart your computer | ||
- | ===== Step 2 - Installing " | + | ===== Step 2 - Installing " |
{{ : | {{ : | ||
- | “Facilia DB” software includes a User Interface and Administration | + | “Facilia DB” software |
+ | | ||
+ | * a database manager | ||
+ | |||
+ | |||
+ | Download and setup: | ||
2.1) **For customers who have purchased the Ecolego Parameter database toolbox**, contact Ecolego support (ecolego@afry.com) to receive the download link for the setup file. | 2.1) **For customers who have purchased the Ecolego Parameter database toolbox**, contact Ecolego support (ecolego@afry.com) to receive the download link for the setup file. | ||
Line 40: | Line 51: | ||
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.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 | ||
- | 4.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 | + | 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 success you will get message **“Database has been created”** | ||
Line 66: | Line 77: | ||
If you have installed SQL Server as named instance - follow the [[additional_instructions|additional instructions]] | If you have installed SQL Server as named instance - follow the [[additional_instructions|additional instructions]] | ||
- | ===== Step 4 - Create administrator user account and first project ===== | + | ===== Step 5 - Create administrator user account and first project ===== |
+ | |||
+ | 5.1) Run **Facilia DB Administration** tool. | ||
+ | |||
+ | 5.2) Enter **user** in the Name fileld and **fdb** in the Password field in the login screen of the tool. | ||
- | Run **Facilia DB Administration** tool. | + | 5.3) Create new user account (using button |
- | Enter **user** in the Name fileld and **fdb** in the Password field in the login screen of the tool. | + | 5.4) Create new project (using button |
- | Create new user account | + | 5.5) Assign newly created |
- | Create new project (using button | + | 5.6) Exit **Facilia DB Administration** tool. |
- | Assign newly created user to the role of administrator of this project (using table Roles). | + | ---- |
- | Exit **Facilia DB Administration** tool. | + | \\ |
+ | [[parameter_database_wiki|Back]] | ||