How to set up Microsoft SQL azure connection in SSRS manager data source

See more:

reporting-services

SSRS-2008

Hi Friends,

I am having SSRS report manager with 2008R2 Version. we already our all reports in this server. Now I am creating new report In Visual Studio 2019. Report data source is Azure SQL.

Connection: Microsoft Azure SQL Database

Authentication: Active Directory Password Authentication

I am querying Azure synapse with using Openrowset Query. its working fine and giving exact results .

I have deployed the report to SSRS Manager. I am unable to authenticate Data source using above credentials. In fact I'm not sure what options to choose.

Failing to understand why my report is not having any connection problem in the visual studio where as facing problem in SSRS manager.

I have tried to authenticate uploaded report in the manager then unable to authenticate.

I tried creating new data source in the manager not able to create.

Can you please help me in this

What I have tried:

--Connection String---
Data Source=ondemand.sql.azuresynapse.net,1433;Initial Catalog=;EncXYZrypt=True;TrustServerCertificate=False;Authentication="Active Directory Password"