Executing privileged commands against MS ADS fails with error 15404
Issue
While login to Microsoft Active Directory (AD) is successful, executing privileged commands intermittently fails within the same session.
Problematic Commands:
CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;
GO
ALTER SERVER ROLE diskadmin ADD MEMBER [Domain\Juan];
While the first command executes successfully, the second command fails with error: Msg 15404, Level 16, State 22, Line 63 Could not obtain information about Windows NT group/user 'xxx', error code 0x80090304.
Environment
You’re using Active Directory authentication with Microsoft SQL Server 2022 on Red Hat Enterprise Linux.
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.