question

salves avatar image
0 Votes"
salves asked growth360-0584 answered

SQL Always On for report services

Hi,

in my searches I found that the report server should not be used in scenarios with SQL Always On, as some information is specific to the report services and even if replicated to another server it will not work.

To work it is necessary to make a series of changes for the replicated database to work.

What is your opinion?

I installed the report server on the three servers and now what do I have to do?

Thank you.

sql-server-generalsql-server-reporting-servicesazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LeonLaude avatar image
0 Votes"
LeonLaude answered Shashank-Singh commented

Hi @salves,

I suggest you go through the official Microsoft documentation below:

Reporting Services with Always On Availability Groups (SQL Server)
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server?view=sql-server-ver15


(If the reply was helpful please don't forget to upvote or accept as answer, thank you)


Best regards,
Leon

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

the documentation is for SQL 2019 and cites versions prior to 2014.

My version is SQL 2016, what should you consider?

Thank you.

0 Votes 0 ·

On the same document on left you have dropdown, go to SQL Server and select 2016 version. I did that for you and here is the link reporting-services-with-always-on-availability-groups-sql-server


0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @salves,

Please refer to this tutorial which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @salves,

Please refer to this tutorial which might help.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BenMiller-DBAduck avatar image
0 Votes"
BenMiller-DBAduck answered

The reality of Reporting Services and AlwaysOn Availability Groups, is that Reporting Services lives on a server and points to a writable copy of ReportServer database. Having the ReportServer database in the AG gives it the ability to failover to the secondaries. The other reality is that the secondary cannot be written to, so you really cannot point the Reporting Services to the secondary to write.

So the option you have is to point the Reporting Services to the AG Listener so that if the AG fails over the Reporting Services still continue to work and keeps it highly available. The challenge will be if you reboot the Primary Server the reporting services will stop until it is rebooted completely. You could do a scaleout Reporting Services implementation if you wanted to.

Only the databases that are used in reports can use ApplicationIntent=ReadOnly in the connection string to leverage the readable secondaries.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

growth360-0584 avatar image
0 Votes"
growth360-0584 answered

We use the SQL Always On for Conversion Rate Optimization and real-time personalization services. We point the Reporting Services to the AG listener so that it works properly!


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.