Installing Planner on Two Servers
It requires user with domain administration rights on both servers and it’s part of the IIS user group on the application server.
Server 1 (Database Server)
SQL Server & SSAS
- Add Callisto Security Assembly Click Here
- Check and if necessary set access rights.
- The user that runs the SQL Server service needs to have sysadmin rights on SQL Server.
- The user that runs the SSAS service needs to have sysadmin rights on SQL Server.
- The user that runs the SQL Server Agent needs to be added to the administrator group due to that it needs to run PowerShellscripts
- Switch off Binary/Collation sort on SSAS if applicable.
Server 2 (Application Server)
- Re-confirm that
- IIS is installed & it has ISAP & CGI, .NET 4.5, ASP.NET.
- Change ISAPI Extension is allowed for .net 4.5 on IIS.
- Microsoft® SQL Server® 2008 R2 Native Client installation (Please install the corresponding SQL Server Native Client, 2012 & 2008 R2 is available in this page from Reference.)
- Planner installed
- Language Format settings need to be English, so the doublenum property type is saved correctly in the modeller
- The SQL Agent user is added to the administrators user group due to allow processing of powershell scripts for night jobs.
- Confirm installation and install if necessary the appropriate Microsoft® SQL Server® Native Client
- Microsoft® SQL Server® 2012/2014 Native Client
- X86 Package (sqlncli.msi)
- X64 Package (sqlncli.msi)
- Microsoft® SQL Server® 2008 R2 Native Client
- X86 Package (sqlncli.msi)
- X64 Package (sqlncli.msi)
- If there is any problem between the connections with both servers, please check:
- Add a new section in web.config in the <system.web> group to allow access from SQL server to the appserver via webservice calls.
- version 1.3 : C:\Program Files\Performance Management Server\Web_Service\web.config
- version 1.4: C:\Program Files\Performance Management Server\CLAdmin\web.config
- Please restart below after re-editing the web.config file:
- for version 1.3 - IIS & CallistoService
- for version r1.4 - IIS, CallistoService & CLRptService
If you get error when deploy sample application for tabular issue, and your SSAS is tabular setup.
Here is the solution: https://pcdesk.freshdesk.com/a/solutions/articles/1000289425
Important Information
IMPORTANT During EFP Installation on Multi Servers
Please type the real ApplicationServerName:PortNumber in ApplicationServer (not localhost:PortNumber)
Please type the real ApplicationServerName:PortNumber in ApplicationServer (not localhost:PortNumber)
- Application
- ApplicationServer - Type the real ApplicationServerName:PortNumber here (not localhost:PortNumber)
- AdminUser - It should be the same user that set up Planner