In the Select a SQL Server section of the Register a SQL Server wizard, specify the SQL Server instance you want to add to IDERA SQL Secure for auditing.

Monitoring Always On Availability Groups

Users can monitor Always On Availability Groups using IDERA SQL Secure. Note that instead of monitoring the listener, you must monitor each individual node of the Availability Group. This is because the security configurations for each of the different nodes of the Availability Group are not always identical and monitoring only the listener could possibly leave gaps in the security check.

To specify an instance:

  1. Select the type of server you want to audit. Available options include:
    • On-Premise SQL Server
    • SQL Server on Azure Virtual Machine
    • Azure SQL Database
  2. Type the name of the instance you would like to audit. IDERA SQL Secure 3.1 supports multi-part server fully qualified domain names entered in the following format:
    name.server.secure.database.net
  3. SQL Server only. Click the ellipsis button  to access a list of monitored SQL Servers in your domain, browse to locate your respective instance, then click OK to add it. This feature is not available when working with Azure VMs or databases.
  4. Click Next to go to the following section and Specify your connection credentials. 

You can add as many instances as your SQL Secure license provides. For more information, see Managing Your SQL Secure Licenses.

IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal

  • No labels