Introduction
With the SQL and SSAS configurations completed in Part 1, we can now finish the setup process by installing Kepion onto the Web Server.
Download Kepion
1. Go to the Kepion Resource Center.
2. Open Software Downloads and then the highest version of Kepion (e.g., v6.1).
3. Download the following files from Manual Configuration.
-
Kepion_System.zip
-
EnableFeaturesOnServer.zip
-
Package.zip
4. (For multitenant only) Download the following from Manual Configuration > Multitenant:
- kepion.override.json
Enable Web Server Features
1. Unzip the file EnableFeaturesOnServer.zip and run in a CMD prompt with Administrator privileges. The EnableFeaturesOnServer.bat script will turn on features on the Windows server that Kepion requires for its Web Server.
2. Open PowerShell with Administrator privileges and run the KepionConfigScript PowerShell script. This script will enable Kepion server event logging on the Windows Server.
Note: After running the script, make sure all the required server roles are enabled.
Now, select the installation option below that best meets your needs:
Manual Installation
Restore Database
Open SQL Server Management Studio (SSMS) and restore the Kepion_System database.
Note: When restoring the system database, you can use the default name (Kepion_System) or a name of your choice.
Configure Registry Items
1. Use the Run command to open regedit.
2. Expand HKEY_LOCAL_MACHINE -> SOFTWARE
3. Right-click and navigate to New > Key. Name it Kepion.
4. Create another Key under the newly created Kepion Key and name it Kepion Planning.
5. Under Kepion Planning, create a third Key using the Kepion version number (e.g., 6.1).
6. Right-click the version number Key and select String Value. Name the value ConnectionString and give it the following value:
Data Source=LOCALHOST;Initial Catalog=Kepion_System;Integrated Security=True
Tip: Replace LOCALHOST with the SQL Server name if configured on a different server and Kepion_System if you renamed the database.
7. Create another String Value with the name InstallPath and set its value to:
C:\Program Files\Kepion Planning version#\
Note: Replace "version#" with the Kepion version you are using (e.g., 6.1)
Set Up the Directory
1. Create the following directory on the machine:
C:\Program Files\Kepion Planning version#\
Note: Replace "version#" with the Kepion version you are using (e.g., 6.1)
2. Copy the files from the downloaded Package.zip to the Kepion Planning directory.
Create the Application Pool
We need to create the application pool from the Internet Information Services (IIS) Manager.
1. Open IIS Manager using the run command inetmgr.
2. Right-click Application Pools and select Add Application Pool…
3. Enter Kepion Planning in the Name field and select the following settings in the Add Application Pool dialog:
4. Select OK.
5. Verify the configuration for the application pool. Make sure the value of the Identity field is the KepionSI you have used throughout the installation process.
Create a Website in IIS
1. To create the actual Kepion Planning Website in the IIS Manager, right-click on Sites and select Add Web Site...
2. Configure the website with the following settings. Be sure to click Select… and select the Application Pool created previously.
3. To enable Windows Authentication, double-click on Authentication.
4. Right-click on Windows Authentication and select Enable.
Tip: If the .bat file we ran earlier didn't execute properly, this option may not appear. To enable it manually, refer to the resources here and here. Also, review the proper configuration from the overview.
5. With the Windows Authentication still selected, click on Providers…
6. Select Negotiate and click Remove.
7. Grant permission to the Kepion SI to access the Web Site by clicking Edit Permissions...
8. On the Security tab, click Edit…
9. Add your Kepion SI, and make sure your Kepion SI has allowed the following:
- Read & execute
- List folder contents
- Read
Launch Website
Open the website in your browser using the following URL:
http://localhost:8888
Multitenant Installation
Restore Databases
1. Open SQL Server Management Studio (SSMS) and connect to your SQL server.
2. Unzip Kepion_System.zip and restore Kepion_System.bak with the following name format: Kepion_System_<Customer>.
For example:
- Tenant #1: Kepion_System_Customer1
- Tenant #2: Kepion_System_Customer2
- Etc.
The Kepion_System database stores Kepion system settings.
Note: You can use a different name for the system database. Please keep the name format consistent. E.g., <systemdbname>_<customername>.
3. Query the [dbo].[SystemAdmins] tables and fill out the following fields:
USE [Kepion_System_Customer1]
GO
SELECT [SystemAdminID], [UserName], [DisplayName], [ModifiedBy]
FROM [dbo].[SystemAdmins]
-
- UserName: Your login <DOMAIN>\<USERNAME>
- DisplayName: Friendly display name
- ModifiedBy: 0
4. Update the table [dbo].[SystemSettings] with the following settings. Make sure to replace <Server-Name> with your own when using the templates.
| Setting | Description |
|---|---|
| DefaultAppDBConnectionStringFormat | This defines the template for the SQL connection string for new Kepion applications. Used by the Kepion Web Server to communicate with SQL databases. |
Template:
Persist Security Info=False;Integrated Security=SSPI;database={0};server=<Server-Name>
| Setting | Description |
|---|---|
| DefaultAppDBOlapConnectionStringFormat | This defines the template for the SQL connection string when connecting from SSAS to SQL relational databases. |
Template:
Persist Security Info=False;Integrated Security=SSPI;database={0};server=<Server-Name>;Packet Size=32767
| Setting | Description |
|---|---|
| DefaultOlapServer | This represents the default OLAP server for new Kepion applications. When you take a Kepion application and “Deploy to OLAP”, a SSAS database will be generated to this server. |
Example:
<Server-Name>
Set Up the Directory
1. Create a directory on the machine for the Kepion Web Server. Notice that the path can be anything that is valid on the machine:
- C:\Kepion.Customer1\
- C:\Kepion.Customer2\
- …
2. Unzip the Package.zip file and copy the contents into the directory.
3. Copy the kepion.override.json file into this directory as well. This file will determine which Application Database to connect to for the Kepion Web Server.
4. Edit the kepion.override.json file by replacing the value for database, server, and Application Name.
For example:
“appHost”: “Persist Security Info=False;Integrated Security=SSPI;database=Kepion_System_Customer1;server=MULTITENANT;Application Name=Kepion Planning Customer1“
Note: Make sure to use the new System database name if you have changed it.
Create the Application Pool
1. Create the application pool from Internet Information Services (IIS) Manager. Launch this from the run command using inetmgr.
2. Right-click Application Pools and select Add Application Pool…
3. Create an application pool for each customer/tenant.
For example:
- Kepion Customer1 AppPool
- Kepion Customer2 AppPool
- Etc…
4. Choose the following settings in the Add Application Pool dialog and select OK.
Note: It is important to set a unique credential for each applicant pool. This will prevent one instance of Kepion Planning from accessing the resources of another. By doing so, we create a security barrier between different customers/tenants on the same machine.
5. Verify the following are configured for each application pool. The Identity field should be filled differently for each Application Pool for enhanced security.
Create a Website in IIS
1. Under MULTITENANT, right-click on Sites and select Add Website….
2. Click Select… and select the Application Pool created in the previous step.
3. Specify the Site name and the Physical path. The physical path should point to the directory that you created for the Kepion Web Server. For each website, enter a unique Port number (i.e. 8888, 8889, etc.).
4. Select OK.
5. Double click on Authentication.
6. Right-click on Windows Authentication and select Enable.
7. With the Windows Authentication selected, click on Providers….
8. Select Negotiate and click Remove.
9. Click Edit Permissions…
10. On the Security tab, click Edit…
11. Add your SI (i.e. CORP\tenantSI1). Make sure the SI has permission to Read & execute, List folder contents, and Read.
12. Select Apply.
13. Repeat Steps 11 and 12 for each customer/tenant that you want to be hosted.
14. After you have added all of your tenants, select OK.
Launch Website
You're done! Try opening the website http://localhost:8888 in your web browser of choice.
Wrap-Up
Once all of the above has been configured to meet your requirements, we recommend you go through our Setup Checklist to make sure you've properly installed Kepion.
Afterwards, take a look at the Sample Apps section to get ideas and inspiration on what you can create, or look into our Modeler Tutorial or Video Tutorials series to follow along with the design, development, and deployment of a Kepion App.
If you have additional questions, or more specific setup concerns and requirements, check out our troubleshooting articles on setting up Kepion. If you have a question that hasn't been answered in this series, please send us a support request and we'll do our best to help out.