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. Additionally, ports 60408 and 65100 need to be open on both local and remote machines for two-way communication.
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.
