Web Gateway Installation for AccuSQL

Web Gateway Installation for AccuSQL

Environment Set Up for Web Gateway

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


Step 2:      Turn on necessary Windows Features


Step 3:      Extract the files in the ZIP and copy the contents to the following location:
"C:\WebGatewayMVC2020"
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:
Description:
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:
https://support.microsoft.com/en-us/help/323972/how-to-set-up-your-first-iis-web-site


    • Related Articles

    • AccuSQL: Why are my students and tutors not receiving email confirmations when setting up an appointment in Web Gateway?

      The main reason this is not occurring is probably that the Email Settings have not been configured on Web Gateway.  This is a separate process then what you may have setup in the AccuSQL application itself but can be copied from the Communication > ...
    • Web Gateway Installation for AccuTrack

      Environment Set Up for Web Gateway Step 1:     Go to Control Panel > Programs > Turn Windows features on or off Step 2:     Turn on necessary Windows Features Step 3:     Extract the files in the ZIP and copy the contents to the following location: ...
    • AccuSQL 2020 (Platinum) Installation Instructions

      AccuTrack 2020 (Platinum) Installation Instructions 1. Click on the HighTail link that was sent to you.  And then click on the Download All button. 2. Click the Save button. 3. Right-click on the downloaded files and Extract all of the files 4. Once ...
    • AccuSQL 2019 Platinum Installation Instructions

      1. Click on the HighTail link that was sent to you. Click the Download All button 2. Click Save 3. Click on the downloaded files 4. Extract all the files 5. Once extracted, double click on the Folder AccuSQL2019_DIST 6. Double click on setup.exe 7. ...
    • AccuSQL: AccuOutlook Add-On Installation

      Gathering Setup Files You will need to copy 1 folder and 2 files from AccuSQL2018Installer\AccuSQL2018_DIST\Program Files\AccuSQL2018 and paste them all to C:\Program Files (x86)\AccuSQL2018  Step 1:      Open File Explorer and Go to ...