2021 EFP Checklist OnPremise

Technical Requirements Checklist On-Premise

3. Internet Information Server (IIS) 6 or higher

a. IIS Windows login service needs to be started.

b. ASP.NET v4.0.30319 needs to be set to allowed on the top level of default site under the “ISAPI and CGI Restrictions”.

c. Windows authentication and Basic authentication are not enabled by default and must be enabled.

4. Microsoft SQL Server 2016, SQL 2017 or SQL 2019 (for a basic EFP installation without pcPortal and Journal drilldown Microsoft SQL Server 2012 R2 is sufficient) a. When using SQL 2019 you will need to follow this procedure during installation Microsoft SQL Server 2019 - Scalar UDF workaround b. SQL Server needs to be installed with collation SQL_Latin1_General_CP1_CI_AS. c. SQL Server services should be setup with Windows domain accounts for multi-server use. d. If Planner is installed on another server than where the ERP source system (E10,E9, iScala or P21), the “ERP- server” must be set up as a linked server on the EFP server. e. SQL Server Agent needs to be started. f. SQL Server Analysis Services needs to be installed with Multidimensional/ OLAP install mode and started. I. Collation for AS: Latin 1_General, no sort order g. SQL configuration with Dynamic Ports is currently NOT supported unless port UDP 1434 access is enabled. I. https://support.microsoft.com/en-us/help/823938/how-to-configure-sql-server-to-listen-on-a-specific- port 5. Local Administrator User access to the server, that can be used as service account with a none changing password 6. TCP/IP protocol should be enabled for SQL Server in SQL Server Network Configuration (SQL Server Configuration Manager) a. Named Pipes protocol should be enabled for SQL Server in SQL Server Network Configuration (SQL Server Configuration Manager, if you use named SQL Instance or multiserver installation) 7. For version 1.4 or later, SQL Server Client Components 8. For version 1.4 or later, 2 User IDs (with “Logon as a batch job” for group policy) with below privileges:

a. User ONE:

I. With Administrator rights on the server II. Administrator rights for SQL Server and SQL Server Analysis Services b. User TWO: II. With standard user rights (No Administrator rights) on the server III. Full Control right to the installation folder of “Performance Management Server” on the server IV. Administrator rights for SQL Server (but No rights to SQL Server Analysis Services)

2 | EFP Technical Requirements Checklist On-Premise

Made with FlippingBook Online document