Share via

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

John Kidd 5 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.

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.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
    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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.