Page History
You can easily and quickly install IDERA The following guidelines estimate the hardware resources required for SQL Secure depending on any computer that meets or exceeds the following hardware, software, and permission requirements. Before installing SQL Secure, also review the product components and architecture as well as how the product works.
Typical requirements
A typical install sets up all SQL Secure components on the same computer. The following table lists the requirements for a typical installation.
the number of SQL Server instances that are registered and the repository grooming schedule applied.
Installs under 20 servers
| Type | Requirement |
|---|---|
| Operating System |
Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 |
Plus:
- .Net framework 4.8
- MDAC 2.8 or later
Supports all editions except SQL Server Express for the following versions:
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017 (Windows)
- SQL Server 2019 (Windows)
- SQL Server 2022
- SQL Server on Azure VM
- SQL Server on Amazon EC2
- SQL Server 2012 SP1
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017 (Windows)
- SQL Server 2019 (Windows)
- SQL Server 2022
- Azure SQL Database
- SQL Server on Azure VM
- Azure SQL Database
- SQL Server on Amazon EC2
- Amazon RDS for SQL Server
Browser for online Help
- Internet Explorer 11.x+
- Microsoft Edge
- Google Chrome
- Mozilla Firefox
Safari
Info Current versions plus three previous versions of these browsers support SQL Secure.
| Note |
|---|
Latest SQL Secure version no longer supports SQL Server 2000, SQL Server 2005 and SQL Server 2008R2 install Secure on a SQL instance with a different collation. |
Console requirements
A console-only installation installs the SQL Secure Console. The console-only installation assumes that a full installation has already been completed on another machine. The following table lists all the requirements for a console-only installation.
Windows 10 Windows 11 | |
| Memory | 8 GB |
| CPU | 6 Core |
| Repository size | Approximately 50GB |
| Recommended SQL Server version | SQL Server 2017 or newer |
Installs 20-50 servers
| Type | Requirement |
|---|---|
| Operating System | Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 Windows 10 Windows 11 |
| Memory | 16 GB |
| CPU | 6 Core |
| Repository size | Approximately 150GB |
| Recommended SQL Server version | SQL Server 2017 or newer |
Installs 51-200 servers
| Type | Requirement |
|---|---|
| Operating System | Windows |
Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019 Windows Server 2022 |
Plus:
.Net framework 4.8SQL Server Versions and Editions
SQL Secure runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.
SQL Secure monitors different SQL Server versions installed on-premise or on cloud platforms.
...
Microsoft Azure VM (IaaS)
...
Amazon EC2 (IaaS)
...
Microsoft Azure SQL Database (PaaS)
...
Collector permission requirements
The following requirements are necessary for the SQL Secure Collector to access the SQL Server instances you want to audit. During install, you can input credentials for a Windows user account or SQL Server login.
...
Windows 10 Windows 11 | |
| Memory | 16 GB |
| CPU | 6 Core |
| Repository size | 200-600GB |
| Recommended SQL Server version | SQL Server 2017 or newer |
Port requirements
SQL Secure uses the default ports opened by the Windows operating system for local and remote communications. To learn about Windows port assignments, see
| Newtab2 | ||||
|---|---|---|---|---|
|
| Newtab2 | ||||
|---|---|---|---|---|
|