The Facilia DB client application includes 2 interfaces, Parameter Database client (Facilia DB) and Parameter Database Administration (Facilia DB Administration). Through these interfaces users can view, add or edit the parameter data.

To open the Facilia DB, select the Start or Search button on Windows, type Facilia DB, and then select the right version of the tool in the search results (ex: “Facilia DB 8.5” or “Facilia DB 8.5 Administration”)

When the Facilia DB client is launched, the user is presented with the login window.

Press the Setup… button.

You must specify the host and login method. See details below.

The following properties must be entered:

• Database name - This is the name of the database. The default name is “facilia_db_template”, but the name might have changed when the database was installed.
• Host - The host name or IP address of the computer where the database is installed. For a local installation you can use 127.0.0.1
• (Optinal) Port - If your database was installed on the default intance of SQL Server - leave this field empty. If you have several instances of SQL server on your computer - identify the right instance by specifying port number. Assigning of the port numbers to instances has been done when database was (see Step 3, Advaced in the Installing the parameter database).

Microsoft SQL Server offers two ways of authentication.

• Windows authentication - This authentication will use your Windows login credentials for authentication. Windows authentication is only possible if you and the database server belongs to the same network and you have been given permission to access the database server.
• SQL authentication - SQL authentication can be used if you and the database server are not on the same network, or if your user account do not have permission to access the database server. SQL authentication requires that you enter a login name and password.

Before you close this window, click the Test connection button to make sure that you can connect to the database.

Once the connection properties have been set up, you should enter the name and password for your personal user account on the database.

Note that for a freshly installed parameter database, please use the following credentials for the default user (administrator):

• Name: user
• Password: fdb

You can select the Remember me button if you want the interface to remember your log in information when you open the client the next time.

When the login information has been entered, click Ok to open Facilia DB 8.5 interface.

Parameter Database Toolbox Wiki - user guide for this toolbox in AFRY ISM.

Back