Announcing the Availability of adutil for RHEL 9 and Ubuntu 22.04 !

We’re thrilled to share that adutil, the Active Directory Utility for SQL Server, is now officially supported on RHEL 9 and Ubuntu 22.04. If you’ve been waiting for this, your patience has paid off! Let’s dive into the details.

[HEADING=1]What Is adutil?[/HEADING]

adutil is a powerful tool that simplifies Active Directory integration with SQL Server on Linux-based deployments. It enables seamless authentication, user management, and keytab configuration. Whether you’re running SQL Server on RHEL 9 or Ubuntu 22.04, you can now harness the full capabilities of adutil.

[HEADING=1]Getting Started[/HEADING]

1. 
   Join Your Host Machine to the Domain: Before diving into adutil, ensure that your host machine is part of the domain. Follow the steps outlined in our article: Join SQL Server on Linux to Active Directory - SQL Server | Microsoft Learn.
    
    
   
2. Installing adutil on RHEL 9: Execute the following commands to add the RHEL 9 Prod repository and install adutil:
   

   sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/9/prod.repo
   ## Now you are ready to install adutil using the command:
   sudo ACCEPT_EULA=Y yum install -y adutil
   ## you can check the adutil version using the command and ensure the version is 1.1.138
   adutil --version
   

   
   

3. Installing adutil on Ubuntu 22.04: Follow these steps to add the repository and install adutil:
   

   ## add the repo and required package signature
   curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc
   curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
   ## now update the repo and install adutil 
   sudo apt-get update
   sudo ACCEPT_EULA=Y apt-get install -y adutil

   
   

[HEADING=1]Explore adutil’s Features[/HEADING]

• Account Creation: Easily create and manage user accounts tied to Active Directory.
  
• Keytab Configuration: Set up keytabs for secure authentication.
  
• User Management: Handle user permissions and access.
  

For detailed guidance, refer to our comprehensive article: Introduction to adutil - Active Directory Utility - SQL Server | Microsoft Learn.

[HEADING=1]Fun Fact: Ansible and adutil[/HEADING]

Did you know that Ansible can simplify your SQL Server deployment? The Ansible-based SQL Server collection leverages adutil behind the scenes to enable AD authentication for SQL Server on Linux. Explore more in the Red Hat Hybrid Cloud Console documentation: Automation Hub - microsoft.sql | Ansible Automation Platform (redhat.com) and our official documentation: Quickstart: Deploy SQL Server on Linux using an Ansible playbook - SQL Server | Microsoft Learn

Get ready to enhance your SQL Server experience with adutil on RHEL 9 and Ubuntu 22.04!

Thanks,

Engineering Lead: Sreekumar V K

Engineering Team: Vaibhao Tatte, Dwaipayan Barman, Parameswara Reddy Bodeddula

Continue reading...