I have created a Group in SQL Server and add in an Active Directory group to it with a users .
When I try to login through Windows authentication , it gives me the following error :
Login failed for user 'UserName'. (Microsoft SQL Server, Error: 18456)
But when I add just an AD user separate from the group ,it has no problem to login .
Why can I not get the logins working from a group ?
I have tried changing the Active Directory settings from global to universal type but that didn't change anything
This on Windows 2016 server machine and SQL Server 2017