Getting started

Table of contents

• Architecture
• Required hardware
• Required software
• Instructions
  • Step 1: Create the application pool and Website in IIS
  • Step 2: Create and prepare the database
  • Step 3: Map the ApplicationPoolIdentity to a SQL Server Login
  • Step 4: Restart the Application Pool and Website

Architecture

This tool is a web-based application built on the MVC framework, with AngularJS and SQL Server as the back-end database.

Required hardware

This tool requires the following hardware or hardware features for successful completion:

Hardware	Description
Minimum physical memory	16 GB RAM recommended
Available disk space	The PC must have at least 8 GB of free space. Disk must be formatted by NTFS file system for better security.

Required software

The tool requires the following software or software features for successful completion:

Software	Minimum version
Client operating system	Windows 7 or higher
Active Directory	Domain joined
Additional server infrastructure	Internet Information Service (IIS) 6.0 or later
SQL Server	Microsoft SQL Server Enterprise Edition 2012 or later

Step 1: Create the Application Pool and Website in IIS

Copying the deployment folder to the web server

1. Download the source code from the repository.
2. Open the solution file EMIEWebPortal.sln in Visual Studio and build the entire solution.
3. Copy the contents of the EMIEWebPortal/ folder to the deployment directory of your Website.

Create a new Application Pool

4. In IIS Manager, expand the local computer, right-click Application Pools, then click Add Application Pool.
5. In the Application Pool Name field, type the name of the new application pool, e.g. EMIEWebAppPool.
6. Select a .NET CLR version of v4.0 or higher, and select Managed pipeline mode as Integrated.
7. Click OK.
8. Select the Application Pool you just created from the list and click on the Advanced Settings option from the Actions pane.
9. Confirm that the Identity value is set to ApplicationPoolIdentity.
10. Click OK and close the dialogue.
11. Navigate to your deployment directory in File Explorer, e.g. D:\EMIEWebApp.
12. Right-click on the directory, go to Properties, and select the Security tab.
13. Add the newly created Application Pool to the list, e.g. IIS AppPool\EMIEWebAppPool, with Full control permissions. Make sure the location is set to search the local computer.
14. Add Everyone to the list with Read & execute permissions.

Create the Website

15. In IIS Manager, expand the local computer, then right-click the Sites folder.
16. Select Add Website.
17. In the Site name field, enter a name for the Website, e.g. EMIEWebApp.
18. Click the Select button and select the Application Pool you created earlier, e.g. EMIEWebAppPool.
19. In the Physical path field, enter the name of the folder that contains the deployment directory, e.g. D:\EMIEWebApp.
20. Configure the Binding Type, IP address, and Port as appropriate. Seek help from your network administrator if you have any questions.
21. Un-check the checkbox Start Website immediately.
22. Click OK.
23. In IIS Manager, expand the local computer, then select the newly created Website, e.g. EMIEWebApp.
24. From the Features View, double-click on the Authentication icon in the IIS section.
25. Enable Windows Authentication. Anonymous Authentication should be enabled by default.
26. Return to the Features View, then double-click on the Connection Strings icon in the ASP.NET section.
27. Open the LOBMergedEntities Connection String for editing.
28. Enter the name of your local computer where it says data source=.
29. Enter the name of your database where it says initial catalog=. The next section will describe how to create the database.

Step 2: Create and prepare the database

1. Launch SQL Server Management Studio.
2. In Object Explorer, connect to an instance of the SQL Server Database Engine, e.g. ..
3. Expand the instance, right-click on Databases, then select New Database.
4. Enter a database name, e.g. EMIEDatabase.
5. Accept all the default values and click OK.
6. Open the 1_CreateEMIETables.sql query located in the DatabaseScripts/Create DB Tables/ folder.
7. Replace the database name placeholder with the name you entered in step 4.
8. Execute the query.

Step 3: Map the ApplicationPoolIdentity to a SQL Server Login

1. Open SQL Server Management Studio and connect to your instance.
2. Expand the instance and open the *Security folder at the server level, not the security folder for the database.
3. Right-click on Logins and select New Login.
4. Do not click Search. In the Login name field, if you have a local SQL Server instance, where IIS and SQL Server are on the same server, enter the name of your Application Pool, e.g. IIS AppPool\EMIEWebAppPool. If you have a remote SQL Server instance, where IIS and SQL Server are on the same server, enter Domain\ServerName$.
   (If a search is executed, it will resolve to an account with ServerName\AppPool Name and Management Studio will be unable to resolve the account's SID, as it is virtual)
5. Open the User Mapping page and check the database you created earlier, e.g. EMIEDatabase. Select db_owner in the list of roles.
6. Click OK.

Step 4: Restart the Application Pool and Website

1. In IIS Manager, expand the local computer, then select the Website you created. Click Restart in the Manage Website pane.
2. In IIS Manager, expand the local computer, then select the Application Pool you created. Click Recycle in the Application Pool Tasks pane.

Step 5: Registering the first user

1. Open your browser and enter the URL for your Website, e.g. http://emieportal:8085.
2. Click Register now.
3. In the Email field, type your name or alias and a drop down will be displayed with the corresponding matches.
4. Select your name from the drop down.
5. Select Role as EMIE Champion.
6. Click Save.
7. Navigate to the administrator console page by entering /#/EMIEAdminConsole in your address bar, e.g. http://emieportal:8085/#/EMIEAdminConsole.
8. A dialog will prompt for the master username and password. The default username is EMIEAdmin and the default password is Admin123. It is recommended that you change the password using the Change password link after your first use.
9. Select your name from the list and click Activate.
10. Navigate to the home page and you should be able to sign in to the portal.