User member of AD group, cannot log into SQL instance

• ManicStar

  SSCoach

  Points: 17992

  More actions

  November 15, 2016 at 1:44 pm

  #314893

  Error: 18456, Severity: 14, State: 5.

  Reason: Could not find a login matching the name provided.

  The AD group has rights to the default database the user is trying to log into, but no matter what I do, i have to register the user outside of the group for SQL to log in.

  I also tried making the new AD group a local admin on the box hosting the sql instance, but I can't get this login to work as a member of the group on the box.

  Scratching head... login is valid not locked out or anything.

• ManicStar

  SSCoach

  Points: 17992

  More actions

  November 15, 2016 at 2:04 pm

  #1912664

  Nevermind all, Firewall woes.

  (hitting head on desk)

• November 17, 2016 at 10:53 pm

  This was removed by the editor as SPAM