How do we configure our NPM reports to read from our Secondary AlwaysON SQL Server Availability Group (Read-Only) instead of reading of from the Primary Database?

Question

We want our NPM reports to read from out Secodnary AlwaysON SQL Server. Is this possible? Support has not been much help at all.

Case # 00244458

mesverrum · Answer

I was suggesting you build your reports completely from scratch in SSRS, there's not existing tool to directly take orion web based reports and migrate them to anything external.

There is a trick where you can see the actual back end SQL of your reports with one of the orion diagnostic tools, Hubble, but it's kind of a hacky way to do things.

Get the sql query of web based report.

rmullal · Answer

How would we deploy the report to SQL Reporting Server? If we know how to do that we can deploy the reports to report server and can configure the connection string inside Report DataSource to use ApplicationIntent.

mesverrum · Answer

There nothing in the software to facilitate that at this time, would need to create it as a feature request.

In the interim you could report from the secondary using something like SSRS.