Azure AD authentication for SSRS hosted in Azure VM

robins 41 Reputation points
2021-11-17T13:02:10.753+00:00

Hi all,

I've been migrating SSRS from on-premise server to Azure VM with SQL server 2019 installed in it. But data source will remain in on-premise. How can we change the authentication from Windows to Azure AD?

Thanks in advance.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,080 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,790 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,382 questions
0 comments
Accepted answer
  1. Marilee Turscak-MSFT 33,706 Reputation points Microsoft Employee
    2021-11-22T20:41:25.963+00:00

    You won't be able to change it from Windows to Azure AD authentication, as SSRS does not support Azure AD authentication. But what you can do is use the Azure Active Directory Application Proxy to connect to the Power BI Report Server and SQL Server Reporting Services (SSRS) 2016 or later. See Configure Power BI Report Server with Azure Application Proxy

    Another way to make this work is to map your Azure AD identities to Windows authentication, as described here.

    Let me know if this helps!

    See also:
    Modernizing SSRS
    SSRS and Azure SQL
    How to setup SSRS with an Azure SQL Server Database

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest