Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Data Access
Created by Guest
Created on Mar 15, 2022

RELATED IDEAS

Multi-factor authentication to connect to Azure database 


Trying to connect to Azure SQL DB (using Active Directory - Password), but every time trying to connect to the DB via Spotfire gets the error : ERROR MESSAGE:
Cannot connect to '<servername>.database.windows.net'.
System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> AdalException: AADSTS50076

If the data source is set to use MFA, then currently it appears there is not possible to access via SQL Server Connector , Looks like Currently only options to authenticate are through windows authentication which will take  windows credentials or active directory- integrated if using azure active directory or active directory-password. Looking for a way to do a multi-step verification for the Azure database and prefer using AD accounts or service accounts.


  • Attach files
  • Guest
    Reply
    |     Jun 20, 2024

    One of our customers is also facing this problem.

    They can not connect to MS SQL Server (configured with Entra ID + MFA authentication) using "Active Directory - Password".

    The customer says that PowerBI can do this without problems.


This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us