Server Requirements
SQL Server install:
- When setting up SQL Server deFacto recommends using 3 separate physical hard drives (1 drive for the OS and LOG(LDF) file, 1 drive for the DATA(MDF) and 1 drive for the tempdb) , when using On-Premise virtual machines please make sure the virtual drives are on 3 separate physical drives as well.
- deFacto recommends premium SSDs as they deliver high-performance and low-latency disk support for virtual machines (VMs) with input/output (IO)-intensive workloads.
Other Server Software requirements:
- .Net 4.5+
- 2 Unique User ID’s & passwords to act as the Service Identity account for deFacto:
- Admin: This deFacto service will run a Windows NT service called “CallistoService” as well as an application pool called “Callisto” and requires the following access:
- Needs to be Administrator on Web Server with install rights
- Needs to be SysAdmin in SQL Server
- Needs to have Administrator Access to SSAS
- Needs to be a Domain user with access to validate users on the Active directory
- Needs to be given login as a service and login as batch job, security rights.
b) User: This deFacto service will run a Windows NT Service called “CLRptService” as well as an application pool called “CallistoUser” and requires the following access:
- Cannot be an Administrator on the deFacto servers.
- Needs to be SysAdmin in SQL Server
- Needs to have NO Access to SSAS
- Needs to be a Domain user with regular User/Domain User access.
- Needs to be given login as a service and login as batch job, security rights.
- IIS with Windows authentication and Basic authentication enabled and Anonymous authentication disabled
With Windows 2008 (IIS 7.0), IIS 6.0 Management must be enabled. Windows authentication and Basic authentication are not enabled by default so they must be enabled manually.
Client Pre-requisites:
- ONLY APPLIES TO OFFICE 2010/2013/2016 NOT OFFICE 365 PRO: When installing Excel please make sure the following are selected to “Run all from my computer” :
- deFacto also recommends disabling Office 365 automatic updates.