DataAccess-Installation-Guide.md

Alta Software PSD2 DataAccess Manual Installation Guide for IIS (Sandbox)

1. Install IIS 10

2. Install the ASP.NET Core Module/Hosting Bundle

   Download the installer using the following link: Current .NET Core Hosting Bundle installer direct download

   For more detailed instructions on how to install the ASP.NET Core Module, see Install the .NET Core Hosting Bundle.

3. Install SQL Server (2016+) or you can use existing SQL server

   1. Run SQL Server Management Studio
   2. Connect to SQL Server
   3. Open new query window
   4. Create database with the following command:

   CREATE DATABASE [PSD2_Portal] COLLATE Latin1_General_100_BIN2;

4. Download latest version of PSD2 DataAccess binaries

   You can download it from our ftp site: Direct download

5. Extract PSD2 DataAccess aplication in IIS folder

   1. Create folder for PSD2 applications, i.e. C:\Inetpub\PSD2

   2. Extract PSD2_DataAccess.zip to C:\Inetpub\PSD2\DataAccess folder

   3. Go to folder, where you extracted PSD2_DataAccess.zip, find appsettings.json file, open it and:

      1. Fill Database:ConnectionString section with database connection string. Database user must have db_owner rights on PSD2_Portal database.

         "Database": {
             "ConnectionString": "Data Source=localhost;Initial Catalog=PSD2_Portal;Integrated Security=true;Application Name=AltaSoft.PSD2.DataAccess"
         }

      2. Fill Authentication section with username and password. This username and password will be used for basic authentication

         "Authentication": {
             "UserName": "User",
             "Password": "Password"
         }

6. Install PSD2 DataAccess in IIS

   1. Go to Internet Information Services (IIS) Manager

   2. Create Application Pool

      

      1. Select Application Pools, right click it and select Add Application Pool...
      2. Enter AltaSoft.PSD2.DataAccess_AppPool into name field
      3. Select No Managed Code in .NET CLR version field
      4. Select Integrated in Managed pipeline mode field

   3. Create Web Site

      

      1. Select Sites, right click it and select Add Website...
      2. Enter AltaSoft.PSD2.DataAccess into Site name field
      3. Select AltaSoft.PSD2.DataAccess_AppPool in Application pool field
      4. Enter C:\Inetpub\PSD2\DataAccess into Physical path field
      5. Configure bindings
      6. Press OK

   4. That's it. 😃

      • Browse this site and ensure, that swagger endpoint is working
      • Check that everything is working as expected