Voltar
-
Título
Error - Default Schema not available -
Descrição
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.” -
Causa
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. -
Resolução
WORKAROUND:
Not using Active Directory Groups.
STATUS
Waiting for fix in a future release of SQL Optimizer for SQL Server.
-
ID do defeito
SOFSS-1724