Hi @Founder
It's quite puzzling when something that worked one day doesn't the next. The error regarding "Integrated Security not supported" typically arises when there's a mismatch in the authentication method expected by the SQL endpoint and the one being provided by your connection setup.
Given that you mentioned this setup was working yesterday, here are a few areas you can explore:
-
Service Principal Credentials: Ensure that the service principal's credentials have not expired or been changed. You can verify and manage your service principal credentials through the Azure portal. For a refresher on creating and managing service principals, please visit Create a service principal.
-
Permission Changes: Verify if there have been any changes to the permissions assigned to the service principal or within the Fabric warehouse that might affect access. Remember, for a service principal to connect, it must have the appropriate roles or permissions assigned. Visit Workspace roles and permissions.
-
Connectivity Method: Ensure that the connection string or method you're using is correctly configured for service principal authentication. This includes specifying the tenant ID, client ID, and client secret (or certificate) of the service principal. Please see Service principal support in Data Factory.
Could you please confirm if there have been any recent changes in your environment that might have affected this setup? If after checking these areas the issue persists, it might be helpful to know:
- Have there been any updates or changes to the Fabric warehouse configuration?
- Are other connections or services experiencing similar issues?
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
