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

Published Aug 19 2020 04:11 PM 1,788 Views

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 'acnet\sqladmin', error code 0x80090304.

1> quit

 

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

Version history
Last update:
‎Aug 19 2020 04:11 PM
Updated by: