To install Engrafo we have created an installer that will help you set up a local website, create a database and of course install the Engrafo Application.

If you choose Docker the setup of web server and database is handled for you. You need to have a Docker Desktop running.

Engrafo Install Helper

Engrafo is a web-application that depends on:

a running Internet Information Server(IIS) - typically installed with your windows installation
a MS SQL Server (e.g. MS SQL Server Express or MS SQL Server) - Don’t worry, we will guide you through download and setup of this in the following

If you need any assistance, please don’t hesitate to reach out to us: contact@engrafo.dk

This page of the Engrafo guide contains information on the following:

1 Installation Steps
- 1.1 Internet Information Server(IIS)
- 1.2 ASP.NET Core Runtime
- 1.3 SQL Server
- 1.4 Setting up a Database
- 1.5 Install Engrafo
2 Start using Engrafo

Installation Steps

The following contains everything you need to know about installing Engrafo and possible prerequisites.

First thing is to get the Install Helper. Head over to Engrafo - Automated Data Catalog & Fast Data Management and click download. From here provide a name and an email-address and request a download link. This will automatically be sent to your given email.

Follow the instruktions in the email to download EngrafoInstaller20.zip and extract EngrafoInstaller.exe.

When launching the Installer, make sure to run it as administrator

The Install helper requires that you have a running web server and a MS SQL Server.

If you are not familiar with setting up a web server and a database, follow the steps below

Internet Information Server(IIS)

If IIS is not present on your Windows installation you can activate it under “Windows Features”:

Just scroll down to where it says “Internet Information Services” and enabled it on the left.

See: Enable or Turn on IIS or Internet Information Services on Windows Server for more information on IIS.

ASP.NET Core Runtime

You will also need to download and install ASP.NET Core Runtime. The Core Runtime enables you to run existing web/server applications. On Windows, we recommend installing the Hosting Bundle, which includes the .NET Runtime and IIS support.

Download the needed version here: direct link to hosting bundle

SQL Server

Lastly make sure to get an SQL Server. If you don’t have a running SQL Server you can download a Windows one here: SQL Server Downloads | Microsoft

We recommend you get the express edition.

When Installing the SQL server, you can choose the Basic settings. (Engrafo will work with SQL server 2014 and forward and SQL Express)

Setting up a Database

For this, we recommend that you use the SQL Server Management Studio (SSMS), which can be downloaded here:

Install SQL Server Management Studio

After downloading SSMS run it and connect to your server, in this case just the computer name.

Start by right-clicking “Databases” and add an empty database by clicking “New Database”. From here add a name eg. EngrafoDB and click “Ok”.

Next, head over to Databases → EngrafoDB → Security → Users and add a new user

Under User type choose “Windows user”. Now click the three dots next to User name, type “NETWORK SERVICE” and click “Check Names”.

You can choose another service account and follow the same instructions with that account

Under User name it should now say NT AUTHORITY\NETWORK SERVICE. Next head to “Membership” on the left. Here choose “db_owner”.

If you work with AD-groups, you can also make the NETWORK SERVICE account member of a DB-owner group.

Finally we just need to map “Logins” to the databases that should be allowed to Login.

Navigate to Security → Logins and find NT AUTHORITY\NETWORK SERVICE. If it is not there just click create login and make it as done above with the new user. Right click the login, select properties and head to “User Mapping”. From here simply map the login to the created database and click ok.

Now you should be ready to install and use Engrafo itself.

Install Engrafo

Finally we are ready to actually install Engrafo.

Start by running the downloaded Engrafo installer as administrator. The installer will also tell you if you have the right prerequisites (webserver and hosting bundle)

Start using Engrafo

By default you get a admin-user when you download Engrafo from www.engrfo.eu

This user has all the privileges to administrate and configure the system. You can use this user to set op AD-groups so that you can assign different roles to different AD-users.

The admin user credentials is in the email you download the installer.

However, we strongly recommend that you create a new admin user and deactivate the default admin user.

If you have any issues please reach out to contact@engrafo.dk

You’ve done it! You’ve installed Engrafo!

Now head over to the section https://engrafo.atlassian.net/wiki/spaces/EDV/pages/258637825and start using Engrafo