Versions Compared

Key

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

...

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.png
  3. From the Folder list on the sidebar, right click on the Security option and select New → Login

    image-20250122-001123.pngImage Added
  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.png
    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.png


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

  6. Press OK to create the SQL Authentication account

...

From the left pane, select the Application Pools folder.
From the App Pools list, right click the FworkCloudConnector (created automatically when creating our site), and select Advanced Settings.

You MUST make the listed changes to your Application Pool, as these will impact the ability for the Cloud Connector to run indefinitely.

...

Setting

Value

Start Mode

AlwaysRunning

Identity

Popup → Type in AD Username/Password

This user account must have access to Read/Write/Modify to the UNC path setup for SupplierConnect attachments.

Idle Time-out action

Suspend

Idle Time-out (minutes)

0

Load User Profile

True

image-20240517-070622.pngImage Removedimage-20250203-214348.pngImage Added

Installing Microsoft Web Deploy

...