...
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 | |
8- 11
- Windows 10
- Windows Server
|
2008 SP2Windows Server 2008 R2Windows Server - 2012
- Windows Server 2012 R2
- Windows Server 2016
- Windows 2019
- Windows Server
|
2019NET Framework 5 SP1 or later |
Microsoft SQL Server for Repository | Supports all editions except SQL Server Express for the following versions: |
2008 R2SQL Server 2012 SP1- 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
|
Microsoft SQL Server for audited instances | |
2008 R2SQL 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
|
| |
0- x+
- Microsoft Edge
- Google Chrome
- Mozilla Firefox
|
Microsoft EdgeSafariSafari 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.
Hardware/software | Requirement |
---|
CPU | 2.0 GHz or higher |
Memory | 2 GB |
32-bit or 64-bit Operating System | |
8- 11
- Windows 10
- Windows Server
|
2008 SP2+ 2008 2012 Server 2012 R2 2016NET Framework 4.6- Net framework 4.8
- MDAC 2.8 or later
|
Browser for online Help | Internet Explorer 9.0 or later |
SQL 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 intalled installed on-premise or on cloud platforms.
SQL Versions Windows Only | On-Premise | Microsoft Azure VM (IaaS) | Amazon EC2 (IaaS) | Microsoft Azure SQL Database |
---|
AWS EC2 | AWS RDS | 2000 | X | 2005 | X | X | 2008 R2 | X | X | X | X |
---|
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 |
Cloud
SQL Secure runs on various Cloud Virtual Machines running Microsoft Windows Server and Microsoft SQL Server.
The following table shows all services that SQL Secure can work with, depending on the could service delivery model and the cloud provider:
Cloud Service Delivery Model | IaaS | PaaS (DBaaS) |
---|
Amazon Web Services | Amazon Elastic Compute Cloud (EC2) | Amazon Relational Database Service (RDS) |
Microsoft Azure | Azure Virtual Machines | Azure SQL Database |
Google Cloud Platform | Google Compute Engine | -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 |
---|
alias | Article 832017 |
---|
url | http://support.microsoft.com/kb/832017/ |
---|
|
on the Microsoft Support site. To better understand how port assignments work when Windows Firewall has been configured, see
Newtab2 |
---|
alias | "Connecting through Windows Firewall" |
---|
url | http://msdn.microsoft.com/en-us/library/aa389286%28VS.85%29.aspx |
---|
|
on the MSDN site.
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) |
...