Administer, manage disaster recovery, and tune performance
Database administrators need reliable, real-time health and status information. They also need to minimize the time and effort spent on the routine administration of databases across the organization. To address this challenge, benefit from IDERA’s bundle of top tools for SQL Server administration.
Simplify daily administration tasks
Manage disaster recovery
agent jobs
Tune for performance, security,
and disaster recovery
SQL Toolbox provides a versatile collection of SQL Server tools, from administration to disaster recovery management and performance tuning.
Reduce time spent on daily SQL Server administration
Manage, discover, and explore your SQL Server environment. Simplify migrating, consolidating, and creating SQL Server instances. Avoid spending countless hours on routine administration, diagnostics, and analytics tasks across multiple instances. Skip writing and maintaining complex and error-prone scripts.
Manage security and permissions
Identify existing vulnerabilities in SQL Server including managed cloud instances. Manage, review, and update security policies. Rank protection with distinct security levels. Scrutinize rights, files, directories, weak passwords, operating system, and more. Analyze and report user permissions and groups across databases.
IDERA Dashboard services requirements
You need to comply with the following requirements to install the IDERA Dashboard:
Type : Microsoft .NET Framework version
Requirement : 4.0 or later
Suggestions : Make sure to install this software prior to the installation of the IDERA Dashboard. For more information about the .NET Framework, see the MSDN article
.NET Framework Versions and Dependencies.
Type : Microsoft Library
Requirement : msolap.dll
Suggestions : The msolap.dll file needs to be installed where the data collection service runs. The installation will search for the file and if it is not found, it 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 ENU\x64\SQL_AS_OLEDB.msi installer).
Type : Operating System
Requirement :
- Windows Server 2008 R2 (86-bit)
- Windows Server 2008 R2 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2016 (64-bit)
- Windows 10 (64-bit)
- Windows 2019 (64-bit)
Suggestions : -
IDERA Dashboard repository requirements
The IDERA Dashboard supports any of the following versions for hosting its repositories:
- SQL Server 2008 R2 - All Editions
- SQL Server 2012 R2 - All Editions
- SQL Server 2014 - All Editions
- SQL Server 2016 - All Editions
- SQL Server 2017
- SQL Server 2019
Browser requirements
The IDERA Dashboard user interface can be accessed via web with the following browsers:
- Internet Explorer IE 10.x+
- Google Chrome
- Mozilla Firefox
- Microsoft Edge
- Safari
Port requirements
The IDERA Dashboard uses the following ports by default:
- Idera Dashboard Core Services port: 9292
- Idera Dashboard Web Application Service port: 9290
- Idera Dashboard Web Application Monitor port: 9094
- Idera Dashboard Web Application SSL port: 9291