Active Directory no working through SQL server Management studio

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

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

Azure SQL database AAD user can't connect

Updated November 02, 2018 18:06 PM

SQL Server 11.0 and AD Groups

Updated December 13, 2018 16:06 PM

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