Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication

• Jignesh Raiyani

  SSC Veteran

  Points: 262

  More actions

  September 8, 2020 at 12:00 am

  #3786082

  Comments posted to this topic are about the item Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication

• TejasAks

  Newbie

  Points: 1

  More actions

  September 14, 2020 at 7:00 am

  #3788187

  This was the old method for configuring AD for SQL on Linux and used to work for RC4 encryption. We learnt that ktutil has a defect which does not allow correct salting of the entries and this will NOT work for AES encryptions. Since the RC4 is disabled by default in RHEL 8 for security reason, this process will definitely not work on RHEL 8 unless security is relaxed. We revisited the process and rewrote it to use ktpass directly on the AD server or a Windows server to generate the keytab instead.

  I would highly encourage revisiting the process mentioned here and change it to conform to the new guidance of using ktpass at following link. It is much cleaner and repeatable, as well as scriptable in most cases.

  https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?view=sql-server-ver15

  https://www.linkedin.com/posts/tejas-shah-72a62027_updated-process-of-configuring-ad-integrated-activity-6620020158473826304-1RPS

• Jignesh Raiyani

  SSC Veteran

  Points: 262

  More actions

  September 14, 2020 at 7:16 am

  #3788188

  Agree with you Tejas.

  • This reply was modified 4 years, 9 months ago by Jignesh Raiyani.