One AD group login not visible to user

• webrunner

  SSC-Dedicated

  Points: 31866

  More actions

  January 15, 2021 at 2:41 pm

  #3833801

  Hello experts,

  I have an odd issue. A user asked me to provision SQL access for an AD group domain\groupB. When I checked, I saw that same AD group already provisioned. I did notice that the user in question was not in the group, so I had him added. But he still could not see the group login when logged in to the SQL Server. Not sure if it matters, but this is an AOAG setup. Also I am sysadmin so I can see everything, which makes it difficult to see the issue through the user's eyes, so to speak.

  So, I see this:

  domain\groupA

  domain\groupB

  domain\groupC

  domain\groupD

  The user sees this:

  domain\groupA

  domain\groupC

  domain\groupD

  Does anyone know what the difference could be that is preventing the user from seeing the SQL Windows login for domain\groupB?

  Thanks for any help.

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 16, 2021 at 3:10 pm

  #3834137

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.