analytics

Installation of DSM Management Suite on a Windows Server 2016

Installation of DSM Management Suite on a Windows Server 2016

Installation of DSM Management Suite on a Windows Server 2016

This article explains how to install the DSM Management Suite backend on a Windows server

Step 1: download the web API

Download the latest version of the DSM Management Suite Web API. This does not differ between the editions. If you ever switch between editions, you do not need to exchange the Web API. Unzip the zip file and copy the folder “DSMMSApi” to the target server. You can also install the API on your BLS. Copy the folder with the DLL files into:

C:\inetpub\dsmmsapi

Step 2: Install requirements

In this step I will not go into the installation of an IIS server. Install an IIS server as described on Microsoft or use IIS Server on which your BLS also runs.

Then download the “dotnet-hosting.2.2” installer package for your IIS and install it. It is important that you use a 2.2 version. 3.x and 2.1.x versions are not supported.

** Download from dotnet-hosting-2.2: ** https://dotnet.microsoft.com/download/dotnet-core/2.2

Step 3: Install MariaDB or MySQL

Download the latest version of MariaDB or MySQL and install it. In this example we will use MariaDB. When installing MariaDB you can directly create a password for the “root” user. Connect to the server immediately after installation by opening HeidiSQL. Create a new database. In this example we use the name “db_dsm”

Step 4: Import the SQL dump

Wählen Sie in MariaDB aus: “SQL Datei ausführen” und wählen Sie die in der Zip beiliegende SQL_Initial.sql Datei aus. Die Tabellenstruktur wird nun für Sie angelegt.

Schritt 5: Neue Website im IIS anlegen

Create a new website using IIS Administrative Manager and give the website an unused port. Select your directory as website directory under:

C:\inetpub\DSMMSApi\DSMMSApi.dll

In this example we use port 8081 and do not use an SSL certificate.

Step 6: Web.config adjustments

Change to the directory in Explorer:

C:\inetpub\DSMMSApi\

Open the web.config file and adjust the settings as follows:

<configuration>
  <location path="." inheritInChildApplications="false">
    <system.webServer>
      <handlers>
        <add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModuleV2" resourceType="Unspecified" />
      </handlers>
      <aspNetCore processPath="dotnet"
                  arguments=".\DSMMSAPI.dll"
                  stdoutLogEnabled="true"
                  stdoutLogFile=".\logs\stdout"
                  hostingModel="inprocess">
<environmentVariables>
    <environmentVariable name="ASPNETCORE_ENVIRONMENT" value="Development" />
    <environmentVariable name="CONFIG_DIR" value="f:\application_config" />
  </environmentVariables>
</aspNetCore>
    </system.webServer>
  </location>
</configuration>

Customize AppSettings.json

The Web API is now almost ready for use, we only have to tell the backend how it gets to the database. For this we open in the directory:

C:\inetpub\DSMMSApi\

The application.json file and adapt the MySQLLocal line:

"MySQLLocal": "server=localhost;port=3306;database=db_dsm;uid=root;pwd=IHR_PASSWORD"

Test connection

Now try to successfully establish a connection with the Settings Manager. If this doesn’t work, check your firewall and proxy settings.

Back to full instructions

Did you like the post?

Become a Patreon and support my work. As a thank you, you will receive exclusive articles, be listed as a sponsor for all my open source projects (do-follow backlink) and get access to exclusive articles.
Don't fancy Patreon? You can also easily support me if you like this article or share it on social media. Thank you!