SQL Server Analysis Services server
The SQL Server Analysis Services server is necessary if you want to create cubes in the application. You can install the SQL Server Analysis Services server on the same server as the SQL Server database or on its own server with the minimum requirements described in the following table.
|
Component |
Requirements |
|
Computer and processor |
4-core, 2 GHz or greater Intel Xeon processor or AMD equivalent |
|
Memory |
16 GB minimum for the SQL Server Analysis Services server only Refer to SQL Server recommendations at https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server (for 2016 or 2017) |
|
Storage |
https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server (for 2016 or 2017) |
|
Operating system |
Windows Server 2019 (Standard or Datacenter Edition) Windows Server 2022 (Standard or Datacenter Edition) |
|
Database software |
SQL Server 2017 CU28 or higher (Standard or Enterprise Edition) SQL Server 2019 C16 or higher (Standard or Enterprise Edition) SQL Server 2022 or higher (Standard or Enterprise Edition) Microsoft OLE Database Driver for SQL Server (*Only required when the SQL Server Analysis Services is a standalone server.) Note: SQL Server as a Service, such as Amazon RDS or Azure Database, is not supported at this time. |
|
Network |
Gigabit Ethernet |