Centralized SSRS instance using multiple data sources

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  February 20, 2015 at 10:17 am

  #1779001

  Wildcat91 (2/20/2015)

  ---

  Could we just have one centralized SSRS install and utilize all of these same reports by creating data sources for each that would point to the appropriate database server?

  Yep, and just set up access to report folders as appropriate.

  Only thing for me would be to check the server it's running on is suitably powerful.

  You could also look into scale-out deployment if you're using Enterprise/BI Editions.

• Alan Burstein

  SSC Guru

  Points: 61152

  More actions

  February 20, 2015 at 11:59 am

  #1779036

  Ditto what Gazareth said...

  Do many shops use this design?

  My experience has been - yes.

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001