none
Providing High availability To SSRS Reports including SQL Server Database for Lync2013

    Question

  • We had set-up SQL Server 2012 for Lync 2013 backend. To provide the high availability to SQL database configured the mirroring concept (Lync 2013 supports only mirroring concept).

    Now problem is we’re not able to provide high availability to SSRS reports with SQL Server connection. Because in SSRS reports configuration manager we had defined the SQL Server principal database connection, If principal database\server goes offline\down then reporting connection get breaks and the reports will be unavailable. Even tried with SSRS reports Scale Out feature It provided availability to reports servers only.

    Can anyone advise me alternative method to providing high availability to SSRS reports?

    Thanks in advance

    Rags

    Tuesday, June 18, 2013 11:14 AM

Answers

All replies

  • Hi Rags,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.


    Charlie Liao
    TechNet Community Support

    Thursday, June 20, 2013 1:52 AM
  • Hi,

    SSRS doesn't provide automatic failover to the mirrored database if primary database is down. You must do manual failover (reconfiguring RS to point the secondary server).

    - http://sqlcat.com/sqlcat/b/technicalnotes/archive/2009/10/23/sql-server-reporting-services-disaster-recovery-case-study.aspx


    Regards,
    Christian HL
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Marked as answer by SuperRags Friday, June 21, 2013 6:13 AM
    Thursday, June 20, 2013 2:56 AM
  • Hi Christian

    Thanks for your instant updates. Is any other way to provide High availability ?

    Regards

    Rags

    Friday, June 21, 2013 6:16 AM