Versions Compared

Version Old Version 4 New Version 5
Changes made by

Matthew Garrett

Sam Pitts

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleServer Installation - Server Manager

From Server Manager, select the “Add Roles and Features” from the Manage option.

image-20240517-063635.png

Press Next on the Before You Begin page.

Select the Role-based on feature-based installation option.

image-20240517-063734.png

From the server selection, choose the destination server for the installation, press Next.

image-20240517-063835.png

From the server roles list, select the Web Server (IIS) role, and when prompted, select “Include management tools (if applicable), and press Add Features.
Press next to add additional features.

image-20240517-063955.png

image-20240517-064001.png

From the features list, tick the ASP.NET 4.7 (or later) option that is available.

image-20240705-023612.png

From the list of role services, add any of the ticked services.

image-20240517-064101.png

image-20240705-041727.png

image-20240705-041454.png

Add the following from the “Application Development” section.

image-20240705-041651.png

Press Next and finalise the addition of the roles to the server.

Creating a SQL Login for the Connector

Open SQL Server Management Studio and connect to the production/test SQL Server.

Note: If you have an existing SQL Login that may already be in use from the ‘SupplierConnect’ portal, this can be used, and this step can be skipped.

Expand
titleSQL Management Studio - Creating a New Login

  1. Open the Microsoft SQL Server Management Studio application.
    Note: These steps can be performed on any computer/server that has access to Management Studio

  2. Connect to the SQL Server that hosts the ‘FworkSQLEcm’ database

    image-20250122-000250.pngImage Added

  3. From the Folder list on the sidebar, right click on the Security option and select New → Login

  4. Enter the required details on the General tab
    Ensure to record these details, as you will need them during the setup of the Connector.

    image-20250122-000504.pngImage Added

    1. Select the SQL Server authentication option

    2. Enter a Login name

    3. Enter a Password

    4. Untick the ‘Enforce Password Policy’ option

  5. From the User Mapping tab, select the FworkSQLEcm database, and tick the db_owner option

    image-20250122-000835.pngImage Added


    The minimum database security options are available here:
    Database Security Considerations - Framework - Confluence

  6. Press OK to create the SQL Authentication account

Create Web Site Folder and Set Access Rights for IIS Users

Navigate to the C:\inetpub\wwwroot directory, and create a new folder caed called “FworkCloudConnector”

...

Add Read/Write/Modify permissions for the built-in group “IIS_IUSRS”

...