I had them recheck, perms match fully between the 2 domain groups.
On the SQL side, there logs show: Error: 18456, Severity: 14, State: 5.
Login failed for user 'PROD-B\dbwillis2'.
Reason: Could not find a login matching the name provided.
So it seems the SQL cant read members of the PROD-B domain group that dbwillis2 is in? because I can login with dbwillis1 that they added directly into the SQL DB
Still testing things with them.....
On the SQL side, there logs show: Error: 18456, Severity: 14, State: 5.
Login failed for user 'PROD-B\dbwillis2'.
Reason: Could not find a login matching the name provided.
So it seems the SQL cant read members of the PROD-B domain group that dbwillis2 is in? because I can login with dbwillis1 that they added directly into the SQL DB
Still testing things with them.....