Page History
...
A typical install sets up all SQL Secure components on the same computer. The following table lists the requirements for a typical installation.
| Hardware/software | Requirement |
|---|---|
| CPU | 2.0 GHz or higher |
| Memory | 2 GB |
| 64-bit Operating System |
Plus:
|
|
| |||
| Microsoft SQL Server for Repository | Supports all editions except SQL Server Express for the following versions:
| ||
| Microsoft SQL Server for audited instances |
| ||
Browser for online Help |
|
| Note |
|---|
Latest SQL Secure version no longer supports SQL Server 2000, SQL Server 2005 and SQL Server 2005, install 2008R2 install Secure on a SQL instance with a different collation. |
...
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.
| Hardware/software | Requirement |
|---|---|
| CPU | 2.0 GHz or higher |
| Memory | 2 GB |
| 32-bit or 64-bit Operating System |
Plus:
|
|
| |
| Browser for online Help | Internet Explorer 9.0 or later |
SQL Server Versions and Editions
...
SQL Secure monitors different SQL Server versions installed on-premise or on cloud platforms.
| SQL Versions Windows Only | On-Premise | Microsoft Azure VM (IaaS) | Amazon EC2 (IaaS) | Microsoft Azure SQL Database (PaaS) | Amazon RDS (PaaS) |
|---|
| 2012 SP1 | X | X | X | X | |
| 2016 | X | X | X | X | |
| 2017 | X | X | X | X | |
| 2019 | X | X | X | X | |
| Azure SQL Database V12 | X |
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.
| Type | Requirement |
|---|---|
| Windows permissions | A Windows user account that has local administrator permissions. |
| SQL Server privileges | A Windows user account that is a member of the sysadmin fixed server role on the SQL Server instance. |
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 | ||||
|---|---|---|---|---|
|
| Type | Requirement |
|---|---|
| SQL Server Object Permissions and configuration collection | Port 1433 (or the configured SQL instance port for the audited instance) |
| Windows file system and registry permissions collection | Port 135 (RPC connectivity) |
...