SQL Server Requirements for Active Administrator 8.6.x (4369665)

SQL Server Requirements for Active Administrator 8.6.x

What versions of SQL Server does Active Administrator 8.6.x support?

The following versions of Microsoft SQL Server are supported. See the Microsoft web site for the hardware and software requirements for your version of SQL Server.

IMPORTANT: 
You must have the credentials of an account that can be used to create a database on the server running SQL Server.

• SQL Server 2014
• SQL Server 2014 Express
• SQL Server 2016
• SQL Server 2017
• SQL Server 2019

IMPORTANT: 
On the server running SQL Server, you must enable Named Pipes communication, which is off by default.

Active Administrator requires the default collation for the audit database. In SQL Server, collation refers to a set of rules that determine how data is sorted and compared. Active Administrator supports only the default collation and sort order configurations for the audit database.

If you are unsure of the collation assigned to the audit database, use the Microsoft ISQL_w or Query Analyzer tools, connect to the database, enter sp_helpsort, and run the statement. The results list all sort and collation information for the database.