This procedure guides you through a typical install of SQL BI Manager integrated with the IDERA Dashboard.
The SQL BI Manager installation kit provides users with a unified installer for both products: IderaDashboard and SQLBI.
- IDERA recommends running the unified installer. See Install the IDERA Dashboard and SQL BI Manager for detailed instructions.
Requirements for installation:
- The SQL Server BI services (SSIS, SSAS, SSRS) should be running under an account that has the required permissions to allow remote connections (i.e. "local system" or a service account in the local administration group).
- The msolap.dll file needs to be installed where the the data collection service runs. The installation will look for the file and if its not found will prompt the user to install the file. This file can be installed by downloading and installing from the latest version of the SQL Server Feature Pack from Microsoft SQL Server 2016 Feature Pack(choose the SQL_AS_OLEDB.msi installer).
- Microsoft SQL Server Shared Management Objects(SMO) needs to be installed. You can install the SMO by downloading the installers from the SQL Server 2016 Feature Pack (ENU\x64\SharedManagementObjects.msi and ENU\x64\SQLSysClrTypes.msi) . Run the SQLSysClrTypes.msi installer first.