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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.