My Blog

ApexSQL TriggerViewer with sql server 2016 on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

ApexSQL Trigger is an auditing tool for SQL Server databases which captures DML/DDL changes that have occurred including information on who made the change, which objects were affected by it, when it was made, as well as information on the SQL login, application, and host used to make the change.

 

ApexSQL TriggerViewer on Cloud for AWS

 

 

Features

Major Features of ApexSQL TriggerViewer with sql server 2016 on cloud

  • View details about data / DML change on each audited operation
  • Include any additional, relevant data to the auditing results for a particular table
  • Transform values e.g. 100 to easy to understand literals e.g. Chicago
  • Fully customize trigger templates with a dedicated IDE
  • Show full audit trail including data as it existed before and after a change
  • Visualize your audit plan directly via the main interface for easy editing
  • Find out the name of the login, host, and application used to make audited changes
  • View all historical modifications to a specific row
  • Be automatically notified about changes made to the table structure
  • View which database object was changed including the DDL action used to make the change
  • Maintain auditing data in the central repository
  • Export auditing data to plain text, Microsoft Excel, or PDF
  • Export audited data to batch script format

 

AWS

Installation Instructions For Windows

Installation Instructions For Windows

Note:  How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

Connect to the virtual machine using following RDP credentials:

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .

Step 2) On the Start page, typeApexSQL TriggerViewer with sql server 2016 on cloud  and then click on ApexSQL TriggerViewer with sql server 2016 on cloud 

Step 3)  Other Information:

1.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

 

 

 

 

Videos

ApexSQL TriggerViewer with sql server 2016 on cloud

Related Posts