SessionLimit v2
  • Infrastructure Documents
  • Overview
    • What is SessionLimit
    • FAQs
    • Road Map
    • Licensing
  • Planning
    • POC Requirements
    • Supported Configurations
    • Windows Server Requirements
    • SQL Server Requirements
    • Other Requirements
    • Network Considerations
    • Design
      • 2Factor VPN Design
      • 2Factor for OWA Access
      • 2Factor for Company Resources
  • Deployment
    • GMSA Account for Application Pool
    • DNS Service Record for Agent Autodiscovery
    • Installing Microsoft SQL Server
    • Internet Information Service Installation
    • .NET Core 8.0 Download and Install
    • .Net Framework 4.7.2 Download and Install
    • HTTPS Certificate
    • Installing SessionLimit 2.1
    • Upgrading SessionLimit
      • Upgrading SessionLimit 2.0.12 to 2.0.13
      • Upgrading SessionLimit 2.0.13 to 2.0.14
      • Upgrading SessionLimit to 2.0.15
      • Upgrading SessionLimit to 2.0.16
      • Upgrading SessionLimit to 2.0.17
      • Upgrading SessionLimit to 2.0.18
      • Upgrading SessionLimit to 2.1.0
      • Upgrading SessionLimit to 2.1.2
      • Upgrading SessionLimit to 2.1.3
      • Upgrading SessionLimit to 2.1.4
    • First Time Wizard
    • Agent Deployment
  • Managing
    • Logging to SessionLimit 2.0
    • Dashboard (Home)
      • General Dashboard
      • My Dashboard
      • Agents Dashboard
    • Policy
      • Session Protection Policy
      • 2FA Policy
    • Limitations
    • Endpoint Management
      • Users
      • Computers
    • Settings
      • General
        • Server Settings
        • LDAP Settings
        • Notification Settings
          • General Notification
          • E-Mail
          • SMS
        • Syslog Settings
        • Syslog Message Settings
      • Advanced Settings
      • 2FA
      • Agent
    • Events
    • Reports
    • Role Management
    • License Management
      • Online License
    • Syslog
      • Logon Operations
  • Agent
    • Session Control
    • 2FA
  • Tips&Tricks
    • SQL Express Usage
    • Fixing 500.19 web.config error
    • Enable HTTPS Redirection in IIS with HSTS
    • Using GMSA Account in Application Pool
    • Give Database Access for GMSA Account
    • What are the SessionLimit protection states?
    • Securing Windows Server
    • How to Create Custom Protected Attribute in Active Directory
Powered by GitBook
On this page
  • Supported versions of SQL Server
  • SQL Server architecture version
  • Database collation
  • Database compatibility level
  1. Planning

SQL Server Requirements

Scope: ARK2FA 2.0

PreviousWindows Server RequirementsNextOther Requirements

Last updated 2 months ago

ARK2FA environment requires a supported SQL Server version and configuration to host the ARK2FA database.

SQL Server can be located on:

  • ARK2FA server computer,

  • A computer that is remote from the site server.

The following instances are supported:

  • The default or named instance of SQL Server,

  • A SQL Server Always On failover cluster instance,

  • A SQL Server Always On Availability Group.

Supported versions of SQL Server

In a hierarchy, ARK2FA server access the same SQL Server database:

  • The SQL Server versions you use remain in support by Microsoft.

  • For SQL Server 2016 and prior, support for each SQL Server version and service pack follows the . Support for a specific SQL Server service pack includes cumulative updates unless they break backward compatibility to the base service pack version

SQL Server 2019: Standard, Enterprise or Express. You can use this version with cumulative update 5 (CU5) or later, as long as your cumulative update version is supported by the SQL Server lifecycle. CU5 is the minimum requirement for SQL Server 2019 as it resolves an issue with scalar UDF inlining.

SQL Server 2017: Standard, Enterprise or Express. You can use this version with cumulative update version 2 or higher, as long as your cumulative update version is supported by the SQL Server lifecycle.

SQL Server 2016: Standard, Enterprise or Express. You can use this version with the minimum service pack and cumulative update supported by the SQL Server lifecycle.

SQL Server 2014: Standard, Enterprise or Express. You can use this version with the minimum service pack and cumulative update supported by the SQL Server lifecycle.

SQL Server architecture version

Configuration Manager requires a 64-bit version of SQL Server to host the site database.

Database collation

SQL Server that's used for the database must use the following collation: SQL_Latin1_General_CP1_CI_AS.

Database compatibility level

The following table identifies the recommended compatibility levels for Configuration Manager site databases:

SQL Server version
Supported compatibility levels
Recommended level

SQL Server 2016

130

130

SQL Server 2017

140, 130

140

SQL Server 2019

150, 140, 130

150

SQL Server 2022

160, 50, 140, 130

160

Microsoft Lifecycle Policy