ApexSQL Log – Permissions and requirements

Applies to
ApexSQL Log

Summary
This article provides information about required permissions and software requirements for ApexSQL Log.

Description

Required permissions for application installation

The Windows user account used to install ApexSQL Log must have Windows administrator permissions.

Installation of ApexSQL Log server-side components (SSC) additionally requires the Windows user account to be a member of the fixed SQL Server sysadmin role.

Note that in case of remote server-side components installation, the Windows UAC feature must be disabled on the remote target machine.

Required permissions for running ApexSQL Log on a database

The Windows user account used to run ApexSQL Log must have Windows administrator permissions. Additionally, the following SQL Server permissions are required:

  • GRANT VIEW ANY DATABASE
  • GRANT VIEW ANY DEFINITION
  • db_owner or the following permissions:
    • GRANT SELECT ON [sys].[partitions]
    • GRANT SELECT ON [sys].[syscolumns]
    • GRANT SELECT ON [sys].[allocation_units]
    • GRANT SELECT ON [sys].[partitions]
    • GRANT SELECT ON [sys].[system_internals_partition_columns]
    • GRANT SELECT ON [sys].[system_internals_partitions]
    • GRANT SELECT ON [sys].[syscolumns]

Note that in case you run ApexSQL Log on a remote SQL Server database, the GRANT EXECUTE ON OBJECT::master.dbo.xp_ApexSQLLog is required.

Software requirements

ApexSQL Log software requirements are specified on the System requirements page.

Hardware requirements

Both minimum and recommended hardware requirements for ApexSQL Log are the same as described on the Hardware and Software Requirements for Installing SQL Server page.