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 |
| 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 | Windows Server 2008 SP1+ Windows 2008 R2 Windows 2012 Windows 2016 |
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 | SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 |
Browser requirements
The IDERA Dashboard and SQL BI Manager's web consoles are compatible with the following browsers:
Internet Explorer IE 10.x and above
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 identifies issues within the SQL BI environment to help optimize BI service performance. Learn more > >