One Server; 2 SQL Instances, 2 Reporting Databases SQL 2019 Enterprise

• alphanew

  SSC Veteran

  Points: 279

  More actions

  December 17, 2021 at 8:15 am

  #3964690

  Hello folks,

  I have two SQL Server instances on one Windows server. The SQL Server is high available. Always On technology. Every instance has an availability group listener. ListenerName1 and ListenerName2.

  Every instance holds a Reporting Server Database. I configured the reporting server with the help oft the reporting server configuration manager like this.

  1. http://<ListenerName1&gt;:80/Reports

  2. http://<ListenerName2&gt;:80/Reports

  If I select http://<ListenerName1&gt;:80/Reports I see the reports oft the instance where the ListenerName1 is pointing at.

  If I select http://<ListenerName2&gt;:80/Reports I see the reports oft the instance where the ListenerName1 is pointing at.

  What I have to do to stop this?

  My purpose is this

  If I select http://<ListenerName1&gt;:80/Reports I want to see the reports oft the instance where the ListenerName1 is pointing at.

  If I select http://<ListenerName2&gt;:80/Reports I want to see the reports oft the instance where the ListenerName2 is pointing at.

  Thanks for help

  Alphanew

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  December 18, 2021 at 9:10 am

  #3965055

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.