IDERA Dashboard and SQL BI Manager services requirements
You need to comply with the following requirements to install the IDERA Dashboard and SQL BI Manager's collection services:
Type | Requirement | Suggestions |
---|---|---|
Microsoft .NET Framework version | 4.0 or later | Make sure to install this software prior to the installation of the IDERA Dashboard and SQL BI Manager. For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies. |
Microsoft Library | msolap.dll | 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 Library | Microsoft SQL Server Shared Management Objects(SMO) | 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). The components in the SQL Server 2016 Feature Pack are backward compatible with all previous SQL Server versions. Run the SQLSysClrTypes.msi installer first. |
Operating System |
|
IDERA Dashboard and SQL BI Manager repository requirements
The IDERA Dashboard and SQL BI Manager support any of the following versions for hosting its repositories:
Edition | Version |
SQL Server Express, Standard, or Enterprise Edition |
|
Monitored BI Service instances requirements
All SQL Server instances that you want to monitor should comply with the following requirements:
Edition | Version |
SQL Server Express, Standard or Enterprise Edition |
|
Browser requirements
The IDERA Dashboard and SQL BI Manager's web consoles are compatible with the following browsers:
- Internet Explorer 10+
- Microsoft Edge (new MS browser in Windows 10)
- Chrome
- Firefox
Port requirements
The IDERA Dashboard uses the following ports:
- Web Application Service: 9290 (Standard HTTP port) and 9291 (SSL port)
- Core Service: 9292 (REST API port) and 9293 (.NET remoting port)
IDERA SQL BI Manager uses the following ports:
- Collection service port: 9277
SQL Business Intelligence Manager helps monitor and manage the health and availability of SSAS, SSRS & SSIS.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal