SQL Server managed by Red Hat Linux Identity Management may fail to execute high privileged command

This article is contributed. See the original author and article here.

Following article describe how to configure Active Directory authentication on SQL Server running in Red Hat operating system using Red Hat Enterprise Linux Identity Management

Tutorial: Configuring Red Hat Enterprise Linux to allow Active Directory users to login to Microsoft SQL Server 2019 leveraging a trust-level setup between Red Hat Enterprise Linux Identity Management and Microsoft Active Directory.

https://access.redhat.com/articles/4094741

Recently we found on SQL Server managed by Red Hat Enterprise Linux Identity Management, if we execute a high privileged command like create user first time it succeeds, if we try to add the user second time it fails with following error.

1>create login test102 with password=’test102′,check_policy=off

2>go

1>create login test103 with password=’test103′,check_policy=off

2>go

               Msg 15404, Level 16, State 22, Server sql-idm, Line 1

               Could not obtain information about Windows NT group/user ‘acnetsqladmin’, error code 0x80090304.

1> quit

 Redhat has acknowledged the issue and a fix is released in Red Hat 8.2

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.