We have a data warehouse and users are trying to browse the database directly from excel. We put those users in an AD group and give them read only permission to a couple of databases.
The problem is under such circumstance users are not able to establish connection from excel to SQL Server. "login failed for user ***" will be shown as error message.
However, if we add every single user's login to SQL Server security, they are able to access to databases from excel then.
Does anyone have any idea why this happens?