Post reply

SSRS with multisubnet AG group

  • February 2, 2018 at 6:29 am

    #326997

    Has anyone successfully setup SSRS with multisubnet AG group.  If so how did you do this.

    Thanks

  • February 8, 2018 at 10:32 am

    #1979064

    I have my production environment set up with a 3 node AG group.  One secondary node is in synchronous replication while the other (DR) is asynchronous. 

    The primary node hosts the ReportServer database while I have the data sources directing towards the secondary node.  I do this by appending my connection string to the listener with:

    ApplicationIntent=ReadOnly; MultiSubnetFailover=Yes

    I hope this helps

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply