Configure Kerberos Authentication on Linux
Summary
How to configure Kerberos authentication for SQL Server on Linux with DxEnterprise.
Information
To join a Linux node to Active Directory and setup Kerberos authentication for SQL Server on Linux please use the following steps.
-
Use the steps in the following Microsoft document to join the Linux node to Active Directory: Join SQL Server on a Linux host to an Active Directory domain
-
Edit the /etc/krb5.conf file to specify the default realm.
[libdefaults]
default_realm = EXAMPLE.COM -
Use the steps in the following Microsoft document to configure Kerberos authentication for SQL Server on Linux: Tutorial: Use Active Directory authentication with SQL Server on Linux
HA Instances: When setting up Kerberos authentication for a Highly Available instance under a Vhost, use the Vhost name instead of the physical server hostname to register the SPNs and create the keytab file with the ktpass commands.
Availability Groups: When setting up Kerberos authentication for availability groups, use the physical server hostname to register the SPNs and create the keytab file with the ktpass commands.