SQL 2008 SSRS to SQL 2012 AOG

• Bobby Glover

  SSCarpal Tunnel

  Points: 4143

  More actions

  November 8, 2012 at 5:12 pm

  #264609

  Will it pose a problem if SSRS 2008 uses SQL 2012 Always on Availability group as its datasource for reports.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 9, 2012 at 12:00 am

  #1557461

  Normally no, but you have to configure your connection as read-intent. (Readable secondaries accept only read-only connections).

  Client Connection Access to Availability Replicas (SQL Server)

  Availability Group Listeners, Client Connectivity, and Application Failover (SQL Server)

  SQL Server Native Client Support for High Availability, Disaster Recovery

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP