Our MS SQL Server is on another trusted domain (Trusted Domain C). We created a Universal Group within Domain A with users from different forest domains and added the AD group onto the SQL Server. When the user from Child Domain B tries to connect, they get the error: "Login failed for user".
If I add the user directly instead of the AD Group in SQL Server, they can login without problems. Furthermore, if I create a AD group in Child Domain B, include all the users from that domain and add it to SQL Server, they have access.
- Domain A
- Child Domain B
- Trusted Domain C
I'm on SQL Server 2016 (13.0.4001.0)
SQL Server error logs displays the error for that particular user:
Reason: Could not find a login matching the name provided.