Now that we have our Kepion SI and SSAS SI credentials with the necessary permissions to access the SQL Server, the next step is to configure our Kepion SI credentials to also have administrator privileges on the SSAS Server.
Add Kepion SI to SSAS
To do this, connect to the SSAS server from SQL Server Management Studio (SSMS) and right click on the server and select Properties.
Select the Security page and click Add to include Kepion SI as an SSAS administrator.
Incremental Deployment (Optional)
In instances where you cannot have Kepion SI as an admin on the SSAS server, please configure the following in each of your Kepion application SQL databases. Set the IncrementalOLAPDeploy to 1 in the table ApplicationSettings.
This instructs the Kepion Server to never drop the existing OLAP database when deploying changes to OLAP. Once this is set, please ensure Kepion SI has admin rights to each of the OLAP databases associated with a Kepion application.
If this is not a concern for your environment, feel free to skip this step.
Restrict SSAS Memory
As in the previous step, restricting the amount of memory used by the SSAS Server is important to ensure a predictable and stable environment. Review the recommendations below:
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 |
Connect to your SSAS Server again in the same way as above: open SSMS and right click on the server in the Object Explorer pane, then select Properties.
Select the General page and configure the Value column for Memory \ TotalMemoryLimit.
Tip: This field is entered as a percentage of the available memory on the server. For example, if your server has 20 GB of memory, you can use 20 to represent 20% of 20 GB, which nets to 4 GB of memory.
Next Steps
We've now configured all the necessary credentials and permissions across our SQL and SSAS Servers. In addition, we've restricted the memory for both of these servers as well. All that's left to do now is run the Kepion Installation and Configuration Wizards and complete the process.
Comments
0 comments
Please sign in to leave a comment.