How to connect to a Synapse Serverless Endpoint from SSRS Report Builder or VS 2017 SSDT NOT using SQL AUTH

John Kidd 0 Reputation points
2023-07-20T21:54:54.76+00:00

I have an on-premise SSRS report server (May 2023 Release) that connects to an existing on-premise SQL database.

I need to also connect to a Synapse Serverless Endpoint. This works with SQL Auth but I need to use a windows account / active directory account to maintain our required security.

At present both the SSRS Report Builder tool and VS 2017 SSDT can connect using SQL Auth but none of the options for other authentication work.

I can connect to Synapse Serverless Endpoint using SQL Management Studio (SSMS) using Azure Active Directory with MFA without issue.

Has anyone gotten this to work.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,115 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,727 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 23,771 Reputation points Microsoft Employee
    2023-07-21T23:12:13.0233333+00:00

    Hello John Kidd,

    Welcome to the Microsoft Q&A platform.

    Synapse Serverless Endpoint only supports SQL and Azure Active Directory authentication and does not support Windows or on-premises Active Directory account.

    Please see the below document for your reference.

    https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/on-demand-workspace-overview#authentication

    I hope this helps. Please let me know if you have any further questions.