Active Directory no working through SQL server Management studio

by Lucy   Last Updated August 10, 2018 12:06 PM

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



Related Questions


TSQL LDAP query via Linked Server

Updated July 10, 2017 10:06 AM

Windows Authentication for SQL Server Linked Servers

Updated October 03, 2017 10:06 AM