I added a group called "Access" and provided access to the group on some of the databases in primary replica which are in always on , when user is tring to connect to the primary server he is getting
Login failed for user 'Domain\Access'. Reason: Attempting to use an NT account name with SQL Server Authentication.
When i checked login is enabled and mode is mixed mode and authentiocation is windows
How to slove the issue