SSRS 2012 Database with Always On Feature is not supported due to AOS server

(0) Share

Report

Posted on by Haytham Said

As per the Notes in this link http://technet.microsoft.com/en-us/library/dd309577.aspx i found that AlwaysOn is not supported for the report server database. what is the recommendation if I want too use the always on Feature with the SQL engine When Installing AX2012.

Any recommendation

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Tommy Skaue Moderator on at

Like (0)

Report

You will need to install one instance without aways on for SSRS and SSIS. Your OLTP (Dynamics AX database) can reside on the instances with AlwaysOn, but SSRS SSAS will require a separate recovery strategy.

Was this reply helpful? Yes No
Haytham Said on at

Like (0)

Report

Thank you for your reply.

As far as i understand i cannot install the SSRS Database on the always on cluster , what about the services ?

Was this reply helpful? Yes No
Tommy Skaue Moderator on at

Like (0)

Report

I'm under the impression you will have to setup a separate SQL Server instance for the SSRS databases and the SSRS service, and this isolated instance can not be in an AlwaysOn pool. So if this instance fails, you will need some other failover solution.

Was this reply helpful? Yes No
Haytham Said on at

Like (0)

Report

Well I am thinking of going to the fail over clustering and create a non clustered instance for the SSRS and SSAS services , still can't figure out a fail over solution for it, i will check the hyper-v options

Was this reply helpful? Yes No
Tommy Skaue Moderator on at

Like (0)

Report

Ok. Report back your discoveries, so we can all learn something. I haven't tested this yet myself. :)

Was this reply helpful? Yes No
Haytham Said on at

Like (0)

Report

ok Will do

Thanks

Was this reply helpful? Yes No
Suggested answer

fsilva-jr 20 on at

Like (0)

Report

Hello!

You can use Scale-Out Deployment for Reporting Services.

Using Scale-Out for SSRS instance and keeping SSRS databases into the SQL Cluster will give you SSRS high availability!

technet.microsoft.com/.../bb522745.aspx

technet.microsoft.com/.../ms156453.aspx

Was this reply helpful? Yes No