Automate configuration of Active Directory authentication for Microsoft SQL Server running on Red Hat Enterprise Linux
Red Hat News, Friday, July 14,2023
Last year, the microsoft.sql.server Ansible role was introduced in Red Hat Enterprise Linux (RHEL). With the release of RHEL 8.8 and 9.2, this role receives a new update with several new features:
- Configure authentication of SQL Server with Active Directory server.
- Expanded management capabilities for Always On availability groups, including support for configuring asynchronous availability replicas and for configuring read-scale always on clusters.
- Configure and manage SQL Server 2022 on RHEL 8 and RHEL 9.
This article covers integration with Active Directory (AD), and guides you through the whole process:
- Ensure that you meet the requirements to configure AD Authentication for SQL Server
- Prepare an Ansible inventory file
- Explore the variables you must set, and prepare an Ansible Playbook file using the role to automatically configure authentication with Active Directory
- Run the role
- Finish the configuration
- Verify that the authentication works as expected
Prerequisites
Before you begin, you must ensure that you meet the prerequisites for the role.