search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

Hyperscale and Reporting Service #44787

Closed gotqn closed 4 years ago

gotqn commented 4 years ago

Is it possible to connect SSRS with Hyperscale replica?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

dimitri-furman commented 4 years ago

@gotqn Yes, you can connect to Hyperscale readable secondary replicas from SSRS by configuring the SSRS data source to have ApplicationIntent=ReadOnly in its connection string. Note that if you have multiple readable secondary replicas, each new connection can land on a different secondary replica.

NavtejSaini-MSFT commented 4 years ago

@gotqn Thanks for the question. Please let us know if any further question or we will go ahead and close the thread by EOD.