Versions Compared

Old Version 23

changes.mady.by.user Daniela Villalobos

Saved on

compared with

New Version Current

changes.mady.by.user Stephanie Mariscal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A typical install sets up all SQL Secure components on the same computer. The following table lists the requirements for a typical installation.

Hardware/softwareRequirement
CPU2.0 GHz or higher
Memory2 GB
32-bit or
64-bit Operating System
  • Windows
8
  • 11
  • Windows
8.1Windows
  • 10
  • Windows Server
2008 SP2
  • 2012
  • Windows Server
2008
  • 2012 R2
SP1
  • Windows Server
2012
  • 2016
  • Windows
Server 2012 R2
  • 2019
  • Windows Server
2016
  • 2022

Plus:

  • .
NET Framework
  • Net framework 4.
6
  • 8
  • MDAC 2.8 or later
Microsoft SQL Server for Repository

Supports all editions except SQL Server Express for the following versions:

  • SQL Server
2008 SP1
  • 2012 
  • SQL Server
2008 R2
  • 2014
  • SQL Server
2012 SP1
  • 2016
  • SQL Server
2014
  • 2017 (Windows)
  • SQL Server
2016
  • 2019 (Windows)
  • SQL Server
2017
  • 2022
  • SQL Server on Azure VM
  • SQL Server on Amazon EC2
Microsoft SQL Server for audited instances
  • SQL Server
2000
  • SQL Server 2005
    • SQL Server 2008
    • 2012 SP1
    • SQL Server
    2008 R2
    • 2014
    • SQL Server
    2012 SP1
    • 2016
    • SQL Server
    2014
    • 2017 (Windows)
    • SQL Server
    2016
    • 2019 (Windows)
    • SQL Server
    2017
    • 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
    9
    • 11.
    0
    • 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.

    Hardware/softwareRequirement
    CPU2.0 GHz or higher
    Memory2 GB
    32-bit or 64-bit Operating System
    • Windows
    8
    • 11
    • Windows 10
    • Windows Server
    2008 SP2+
    • 2012
    • Windows Server
    2008
    • 2012 R2
    • Windows Server
    2012
    • 2016
    • Windows
    Server 2012 R2
    • 2019
    • Windows Server
    2016
    • 2022

    Plus:

    • .
    NET Framework 4.6
    • Net framework 4.8
    • MDAC 2.8 or later
    Browser for online HelpInternet 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 installed on-premise or on cloud platforms.

    SQL Versions Windows OnlyOn-Premise

    Microsoft Azure VM (IaaS)

    Amazon EC2 (IaaS)

    Microsoft Azure SQL Database

    AWS EC2AWS RDS2000X2005XX2008

    (PaaS)

    		Amazon RDS (PaaS)
    2012 SP1XXX
    2008 R2

    		X
    XXX2012 SP1
    2016XXX
    		X
    2016
    2017XXX
    		X
    2017
    2019XXX
    		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.

    TypeRequirement
    Windows permissionsA Windows user account that has local administrator permissions.
    SQL Server privilegesA 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
    aliasArticle 832017
    urlhttp://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"
    urlhttp://msdn.microsoft.com/en-us/library/aa389286%28VS.85%29.aspx
    on the MSDN site.

    TypeRequirement
    SQL Server Object Permissions and configuration collectionPort 1433 (or the configured SQL instance port for the audited instance)
    Windows file system and registry permissions collectionPort 135 (RPC connectivity)
    Scroll pdf ignore
    Excerpt
    Newtabfooter
    aliasIDERA
    urlhttp://www.idera.com
    |
    Newtabfooter
    aliasProducts
    urlhttps://www.idera.com/productssolutions/sqlserver
    |
    Newtabfooter
    aliasPurchase
    urlhttps://www.idera.com/buynow/onlinestore
    |
    Newtabfooter
    aliasSupport
    urlhttps://idera.secure.force.com/
    |
    Newtabfooter
    aliasCommunity
    urlhttp://community.idera.com
     |
    Newtabfooter
    aliasResources
    urlhttp://www.idera.com/resourcecentral
    |
    Newtabfooter
    aliasAbout Us
    urlhttp://www.idera.com/about/aboutus
     |
    Newtabfooter
    aliasLegal
    urlhttps://www.idera.com/legal/termsofuse

    ...