Introduction
Welcome to Kepion! This overview explains everything you need to set up and know before you start installing Kepion to your environment. Carefully review the information below to ensure your installation goes smoothly.
Kepion environment
A typical Kepion environment consists of three key components and two service accounts. It's up to you whether you want to configure these components on the same machine or separate ones.
Note: When the credentials KepionSI and SSAS SI are used across machine boundaries, those credentials and the target machines must all belong to a common Active Directory service.
The components are:
- SQL Server: Where the relational SQL Database Engine is installed.
- SSAS Server: Where the SQL Server Analysis Services is installed.
- Web Server: Where the IIS is running.
The service identities are:
- Kepion SI: A credential that determines the running context for the web server. We recommend using a dedicated domain account as the Kepion SI.
- SSAS SI: A credential that determines the running context for the SSAS server.
Software requirements
You must have installed everything in the following list to set up and use Kepion. We recommend you first install all the required software and then perform a single reboot to register everything at once.
-
Relational SQL Server
- Microsoft SQL Server 2014 (or later 2016, 2017, 2019*)
- Edition: Enterprise, BI, Standard**
-
OLAP SSAS Server
- Microsoft SQL Server Analysis Services 2014 (or later 2016, 2017, 2019*)
- Edition: Enterprise, BI, Standard**
-
Web Server
- Microsoft IIS 7.0
- .NET Framework 4.8
- SQL Components based on the installed SQL version:
- Microsoft® SQL Server® Analysis Management Objects
- Microsoft® SQL Server® ADOMD.NET
- (If using SQL Server 2014-2019) Microsoft® SQL Server®2012 Native Client
- (If using SQL Server 2022) Microsoft OLE DB Driver for SQL Server
* If you are downloading SQL Server 2019, please also download the SQL Server 2019 Cumulative Update.
** Learn more about Kepion SQL Standard Support.
Memory requirements
To ensure optimal performance, you should review the memory configurations for the SQL and SSAS servers. By default, SQL and SSAS servers consume all available memory on a server. Total memory consumption can lead to unexpected behavior and poor performance.
The tables below provide recommendations for memory allocation in a typical environment. If each server is on its own machine, ensure that the host OS also has at least 2 GBof memory. We will cover this information in further detail during the setup process.
Production Environment
Number of Users | Web Server | SQL Server | SSAS Server |
---|---|---|---|
Small < 10 | 2+ GB | 4+ GB | 4+ GB |
Medium < 50 | 4+ GB | 6+ GB | 6+ GB |
Large > 50 | 6+ GB | 8+ GB | 8+ GB |
Development Environment
Number of Users | Web Server | SQL Server | SSAS Server |
---|---|---|---|
Small < 10 | 2+ GB | 3+ GB | 3+ GB |
Server permissions
Check that you have the server permissions necessary to configure the three components across the various servers within the environment.
Machine | Permission | Description |
---|---|---|
Web Server | Machine Administrator | Need to be an admin on the Web Server to install to IIS. |
SQL Server | SysAdmin | Need to be an admin on the SQL Server in order to add the Kepion SI login. |
SSAS Server | SSAS Administrator | Need to be an admin on the SSAS Server in order to add the Kepion SI as an admin. |
Tip: To configure the SQL and SSAS Server, view the Configure SQL and SSAS article.
Kepion SI consideration
Kepion SI is a credential that determines the running context for the web server. You need to think about whether you need to create a new credential or use your own as the Kepion SI:
- Create a new credential: If you are working in a production or development environment, it is recommended to have a dedicated domain account for your Kepion SI. Please request an account to be created on your domain, e.g. Domain\KepionSI.
- Use your own credential: This option is recommended if you're working in a sandbox environment (for demo and prototyping purposes) and have sysadmin privileges. The credential usually comes in the form MachineName\UserName.
We will revisit credentials in more detail in later parts of the Setup Guide. Just start thinking about what would fit your needs best.
Kepion installation
If your system meets all the requirements above, you can begin installing Kepion. We have split up the setup process into three parts:
- Part 1: Configure SQL and SSAS
- Part 2: Standard Installation (Recommended) OR Manual/Multitenant Installation
- Part 3: Set Database Permissions for SSAS SI
- (Recommended but optional) Go through the Setup Checklist to ensure proper installation
Note: All users will complete part 1 in the same way. However, part 2 can be completed the standard way (highly recommended for most users) OR manually for single-machine or multi-tenant setups.