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.
• 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 execute the statement. The results list all sort and collation information for the database.