October 8, 2017 at 5:57 am
Hi
I have 2 servers connecting by hadr with listner.
All my reports and ETL work on the secondary .
I have reports that run online , so we decided when the secondary execute the ETL.
I want to execute this report on the primary, and not allow any command of read only on the secondary .
I execute this command:
ALTER AVAILABILITY GROUP [AG_HADR1] MODIFY REPLICA ON N' XXXXXX' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = no));
i checked on profiler and the reports excecuting on the primary, until here work fine.
when I want to return to first setting and allow read only on the secondary I execute this command:
ALTER AVAILABILITY GROUP [AG_HADR1]MODIFY REPLICA ON N'XXXXX' WITH (SECONDARY_ROLE(ALLOW_CONNECTIONS = all))
the reports still execute on primary , only after I restart the ssrs service the reports back to execute on the secondary .
How can I get reports execute back on secondary without restarting ssrs services?
October 9, 2017 at 6:26 am
Consider using the ReadOnlyRouting and the ApplicationIntent=ReadOnly switch in your connection string for the read-only readers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply