This article offers answers to frequently asked questions regarding ApexSQL Audit installation that will help users to understand and get through the installation process with ease
Can more than one ApexSQL Audit GUIs be used for a single audited instance?
Since installation of ApexSQL Audit GUI is joined with the installation of the central repository database and central service, it is not possible to install multiple GUIs for the same central repository/service. With that being said, there are 2 different cases:
- Users are on different machines – it is not possible to use ApexSQL Audit GUI
- Users are on the same machine – all users can use ApexSQL Audit GUI
Can more than one installation ApexSQL Audit Web reports be used for a single audited instance?
Yes, there is no limit to the number of ApexSQL Audit Web reports that can be used for any number of audited instances
Do I need a license for a separate instance for the central repository database, if it isn’t on the same instance as the audited server?
No, the SQL Server instance that hosts central repository database does not need a separate license if it is not audited
Why do I need a local SQL Server?
A local SQL Server is needed to host the central service. This is necessary since it collects data from remotely audited instances into the central repository database. This setting enables higher security as well as better performance.
Do I need SQL Server Reporting Services to run the web reports?
No, SQL Server Reporting Services is not needed to run web reports, or by any other component/feature of ApexSQL Audit
If I activate a server for auditing, can I later move the license/activation to another server?
Yes, the license can be moved from one SQL Server to another. To do so, simply Remove the SQL Server you do not want to audit any more. This will remove a selected server from the license and make one additional server available in the license that can later be used to activate a completely different server.
Activation, on the other hand, cannot be transferred between servers without approval from ApexSQL. Simply email email@example.com if you get activation warnings.
Can I install the ApexSQL Audit service (instance) remotely on one or multiple machines
Yes you can, and here is a detailed description of the remote installation of the ApexSQL Audit auditing instance (service).
Is it possible to deploy and install the ApexSQL Audit auditing instance on a SQL Server Failover cluster
Yes, ApexSQL Audit supports auditing a SQL Server Failover cluster instance, and here is a detailed guide to deploy, configure and add a SQL Server Failover clustered instance for auditing
What are the permissions and software requirements for ApexSQL Audit installation
Detailed explanation of hardware and software requirements can be found in this article
How do I install the different ApexSQL Audit components?
Here is a detailed guide about installing ApexSQL Audit components