Web Gateway Installation for AccuSQL

Web Gateway Installation for AccuSQL

Environment Set Up for Web Gateway

Step 1:  Turn on necessary Windows Roles & Features

Windows 7/8/10:

  1. Go to Control Panel > Programs > Turn Windows features on or off.

  2. Turn on necessary Windows Features

Windows Server 2012/2016/2019:

  1. Open Server Manager:
  2. Select Add Roles & Features:
  3. Enable the following environment variables to match these screenshots:
    1. Web Server IIS
      1. Web Server
        1. Common HTTP Features
          1. HTTP Redirection

      2. Security
        1. Basic Authentication
        2. Client Certificate Mapping Authentication
        3. Digest Authentication
        4. IIS Client Certificate Mapping Authentication
        5. Windows Authentication

      3. Application Development
        1. .NET Extensibility 4.7
        2. ASP.NET 4.7
        3. ISAPI Extensions
        4. ISAPI Filters
        5. Server Side Includes

    2. .NET Framework 4.7 Features
      1. WCF Services
        1. TCP Port Sharing

Step 2:      Extract the files in the ZIP and copy the contents to the following location:

NOTE: The location above should only contain the contents shown below:

Setting the Database Locations

Step 1:      Go to C:\WebGatewayMVC2020\ClientBin. and Run SetDataLocation.exe

Step 2:      Click on New.

Step 3:    Click Yes for a SQL Server connection.


Step 4:      Fill out the SQL server connection information and Click Save.

NOTE: These are brief descriptions of what the fields and options are in this tool:
Used to define the “Choose Lab” drop-down box presented in Web Gateway at login.
Authentication: If you are using SQL Server authentication to connect to the database, select that option from the drop-down, else you can select Windows Authentication.
User Name: if using SQL Server authentication, enter the user name for the account you will be using to connect to the database. If Windows Authentication, this field will be grayed out.
Password: if using SQL Server authentication, enter the password for the account you will be using to connect to the database. If Windows Authentication, this field will be grayed out.
Database: Select the drop-down to see a list of databases available (it may take a few seconds to populate). Select the AccuSQL database you will be using for this connection.
Test Connection: Click this button to test your database connection. If it returns with anything other than Test Connection Succeeded, check your connection information again and retest.
Use as Default: This will be the first database connection to show in the list.

Step 5:    Select the local lab you want to be available in the drop-down box at sign-in on Web Gateway. After you have made your selection, Click OK.


Step 6:      You will be brought back to this window. Click Save and then Click Close.

TIP: You can set up multiple local labs by following Steps 1 - 5 of Setting the Database Locations.

Setting the Email Server Connections

Step 1:      Go to C:\WebGatewayMVC18\ClientBin and Run GetEmailSettings.exe

Step 2:      Fill out the email server connection information and Click Save.

Email server connection information will be used to email appointment confirmations to students and/or tutors when appointments are scheduled (or canceled) using Web Gateway.

Step 3:      Close out of the application by clicking the X on the upper-right hand corner.

Adding the Application to Internet Information Services (IIS)

Step 1:     Add a new Application Pool.

Step 2:      Fill out the Name and set .NET CLR to Version v4.0.30319.  Click OK.

Step 3:      Select the application pool, right-click, and choose Advanced Settings.

Step 4:      Set Enable 32-bit Applications to True and click OK.

Step 5:      Right-click Default Web Site and choose Add Application.

Step 6:      Name the Alias, Select the Application Pool that was created, and Set the Physical path to the root folder on which Web Gateway MVC was installed.

Click Test Settings.

  1. You may get this pop-up after clicking Test Settings so just click Close if everything does not pass correctly.

  2. Click Connect As...

  3. Select the Specific User option and click the Set... button.

  4. Verify that the <domain>\<username> has Read/Write/Modify access to the install folder or the Web Gateway MVC physical path, as well as Read/Write/Modify permissions on the AccuSQL database.  Click OK when done.

  5. You will return to the Add Application window.  Click Test Settings once again.

  6. You should see all green check-marks if they pass the Authentication and Authorization requirements and then simply click Close.
If all is good simply click OK to exit this screen.

Step 7:      Select the WebGatewayMVC application and click Browse *:80 (HTTP).

Step 8:     Done!  Students can begin using Web Gateway!

Important!  This guide does not cover how to host the website to be available online.  But at this point, the website should be available on the local network for users to access on-campus.  You may need to consult your website development team on how to host an IIS server online or read this Microsoft KB Article: