Onpremise Installation of Pronestor software and license

This is a guide on how to install Pronestor Planner on an on-premise server.
Before installing please ensure that the following condition is met in regards to licensing:

IMPORTANT - Access to https://license.pronestor.com from the installation server is required. This is required for validation of licensing. Failing to do this will result in a server error.

Below you’ll find installation and configuration for 2008 servers (IIS 7) and newer.

• Create folders and extract files to folder
• Configure Internet Information service
• Create application pool
• Create virtual directory
• Setup database connection

Create folders and extract files to folder

1. Create a “pronestor” folder in “c:\inetpub\wwwroot” folder
2. Create a “install” folder in “c:\inetpub\wwwroot\pronestor” folder
3. Download the installationfiles from http://help.pronestor.com/download/
4. Extract the content of zip files to the install folder “c:\inetpub\wwwroot\pronestor\install”
5. Copy the license key, Pronestor.lic to “pronestor\install\License” (this is given to you by Pronestor)
   
6. Open command promt as administrator. This is done by right clicking the command promt icon and say run as administrator.
7. In command promt go to the path where you put the files, c:\inetpub\wwwroot\pronestor\install
   
8. While in this folder, type in "run FULL_INSTALL.bat"

Create application pool

1. Go to IIS
2. In the left menu right-click Application Pool
3. 
4. Choose “Add Application Pool…”
5. Call the application pool for “Pronestor pool”

6. 

7. Ensure that “Integrated mode” is chosen in Managed pipeline mode
8. Ensure that it runs with .NET 4.0 framework
9. Click OK to save and continue

Note - SQL Express
If you are using a Microsoft SQL Express please configure the app pool with:

1. Right click the “Pronestor pool”
2. Choose Advanced Settings
3. Load User Profile = True

Note - application pool recycle

We recommend that you set the application pool to recycle once a day, outside business hours. After the recycle, the site will hibernate until the first user of the day logs in and access the site. Scheduled reports won't be send during the hibernation, so ensure they are set to send before the application pool recycling.

Create virtual folder

1. Expand Default Web Site in the left side menu
2. Right-click pronestor and choose “Convert to Application…”
3. Set Application pool to “pronestor Pool” – using the Select button
4. Click OK button

Note – Enabling Single-Sign-on
If you do not allow the application to create and populate the database itself – please see section
5.4 Enabling single-sign-login (Windows Authentication – IIS 7)

Configure SQL connection

1. Open “c:\inetpub\wwwroot\pronestor\configuration\connectionStrings.config” in notepad or similar
2. You now need to insert information regarding the SQL server, name of database, and the login information of the SQL user login we created in the previous section.
   

   a. Data Source : name of database server (In this guide referred to as kasper_7-pc\sqlexpress)
   b. Initial Catalog : name of database (In this guide referred to as PronestorDB)
   c. UID: name of SQL login (In this guide referred to as PronestorUser)
   d. PWD: Password for the SQL login

3. Edit the 2. line to contain this information like:
   <add name="dbConnectionString"
   connectionString="Data Source=kasper_7-pc\sqlexpress;
   Initial Catalog=proNestorDB;
   UID=PronestorUser;
   PWD=MySecretPassword"
   providerName="System.Data.SqlClient" />
4. Save the file

Note – SQL Connection string for Windows Authentication
If you require that Windows authentication mode to be used towards the Pronestor database, then you must write this in the connection as well.
Notice – no user and password is to be written in the connection string – only that it is to use “integrated security=True”

<add name="dbConnectionString"
connectionString="Data Source=kasper_7-pc\sqlexpress;
Initial Catalog=proNestorDB;
Integrated Security=True"
providerName="System.Data.SqlClient" >