The customer run a process in SQL Optimizer with a user forming a part of an Active Directory group that has a SQL login with DB owner permissions for the database. When the user member of the group tried to run a SQL Scan it failed with the error
“This job had an error during the process of scanning SQL: Default Schema not available.”
If the same user logins with the same Active directory user but instead of being inside a group connects directly using a login it will run without issues.
