Cloud Connector - IIS Setup and Configuration
- Matthew Garrett
- Sam Pitts
Table of contents
- 1 Overview
- 2 Enable Internet Information Services (IIS) and ASP.NET
- 3 Creating a SQL Login for the Connector
- 4 Create Web Site Folder and Set Access Rights for IIS Users
- 5 Configure Web Site
- 6 Configure Application Pools
- 7 Installing Microsoft Web Deploy
- 8 Deploying a Website in IIS
- 9 Modify Site Settings
- 10 Check Access to Site
- 11 Amending Connection Settings (If Required)
Overview
Framework Cloud Connector is a stand-alone IIS service, that is deployed on-premise to connect Framework ECM to the Perspective Systems to allow use of the “SupplierConnect” application. This includes sending, receiving and updating notifications issued by the office, and updating office data with call up information made by site supervisors.
The below guide details the step-by-step instructions on how to install and configure the Framework Cloud Connector Solution.
Enable Internet Information Services (IIS) and ASP.NET
Open Server Manager on the destination server.
Note: the same installation steps can be performed on a workstation using “Add Programs and Features”.
From Server Manager, select the “Add Roles and Features” from the Manage option.
Press Next on the Before You Begin page.
Select the Role-based on feature-based installation option.
From the server selection, choose the destination server for the installation, press Next.
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.
From the features list, tick the ASP.NET 4.7 (or later) option that is available.
From the list of role services, add any of the ticked services.
Add the following from the “Application Development” section.
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.
Create Web Site Folder and Set Access Rights for IIS Users
Navigate to the C:\inetpub\wwwroot directory, and create a new folder called “FworkCloudConnector”
Add Read/Write/Modify permissions for the built-in group “IIS_IUSRS”
Once added, your directory for inetpub\wwwroot should look like this.
Configure Web Site
Open IIS Manager from the Start menu.
In IIS Manager, from the left pane, right click the “Sites” folder and click the Add Website option.
Add the following details into the Add website dialog and press OK.
No further additions or selections are needed at this stage.
Field | Value |
|---|---|
Site name | FworkCloudConnector |
Physical path | C:\inetpub\wwwroot\FworkCloudConnector |
Port | 89 |
Configure Application Pools
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.
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 |
Installing Microsoft Web Deploy
To deploy a website to IIS, “Microsoft Web Deploy” is required to be installed.
This is available at the below URL:
Select the appropriate version from the site (32/64 Bit, English US).
Note: Fully featured web deploy is unavailable unless the IIS Management Service is enabled.
Please ensure this is enabled BEFORE installing this application.
When installing, select the Custom installation option.
Ensure that the IIS Manager UI Module and IIS Deployment Handler are installed as “Full features will be installed”.
Deploying a Website in IIS
Open IIS Manager, and navigate to the previously created site in the left-hand pane.
Right click the FworkCloudConnector site and select the Deploy → Import Application… option.
If the Deploy option is missing for you, ensure you have followed the steps above to install the Web Deploy application.
Select Browse and navigate to the .zip package on the server, then press Open and Next.
Click next on the ‘Select contents’ as all options should be automatically selected.
Clear out the Application Path (i.e., make it blank), and enter in the following details.
Datasource - Server Name and Instance Name (where applicable). E.g., SQLSERVER2024\MYINSTANCE
Catalog - Database Name. E.g., FworkSQLEcm
User ID - SQL Authentication username.
Password - SQL Authentication Password.
When selecting Next, press OK on the dialog that warns about root folders.
Select the second option about deleting extra files, press Next.
Click Finish to complete the deployment process.
Modify Site Settings
After successfully deploying the package, right click on the site, and go to Manage Website → Advanced Settings
Ensure that the Preload Enabled is set to True.
Check Access to Site
Click on the site inside IIS Manager, and from the right pane, select the Browse option on port 89.
If the setup has been completed successfully, a tick should appear against the connection Valid and Base URL Valid.
Amending Connection Settings (If Required)
Navigate to this location in File Explorer:
C:\inetpub\wwwroot\FworkCloudConnector
Edit the Web.config file in Notepad.
Amend the connectionStrings setting to include your required details.
If you are still unable to successfully load the web page (with valid settings), ensure that you are able to authenticate with the credentials in SQL Server Management Studio for your user id and password.
You may need to give additional access to this account.
If you need assistance with permissions to the Framework databases, refer to our KB Article below.
Database Security Considerations - Framework - Confluence (atlassian.net)