Error - Default Schema not available (4344779)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Error - Default Schema not available
Description

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.”
Cause

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.
Résolution

WORKAROUND:

Not using Active Directory Groups.

STATUS

Waiting for fix in a future release of SQL Optimizer for SQL Server.
Identifiant du défaut

SOFSS-1724

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 5/24/2022
Dernière mise à jour le : 10/27/2023

Titre