web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How to add Reporting Services to an existing SQL Server Clustered Instance

(0) ShareShare
ReportReport
Posted on by

Hello

i want setup report services in Stand-alone server is far from SQL Server .
After the completion of the task I want to setup AOS in a third server

please advise best practices

*This post is locked for comments

I have the same question (0)
  • Mea_ Profile Picture
    60,284 on at

    Hi Mohamed Abdallah,

    In relation to AX you can check this link technet.microsoft.com/.../dd309577.aspx

    However, I think it's more SSRS reported question than AX.

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Reporting services is not capable of true clustering, especially for AX.

    What you could do is a so called scale-out deployment for the SSRS instances with a Network Load Balancer. I am having 2 SSRS instances deployed pointing to a single ReportServer database that is in the HA cluster. AX points to the NLB, and both instances are serving requests. The SSRS instance can only point back to a single AX AOS service, so if that goes down, manual intervention is still required on the two reporting instances to switch the AXC file unfortunately in a DR scenario.

  • Community Member Profile Picture
    on at

    Dear Vilmos Kintera

    We need implement setup single report server and single SQL server and AOS single Server

    please answer below questions

    - What we need setup prerequisites in three servers ?

    - What we need setup component SQL Single Server ? 

    - What we need setup component Report Single Server ? 

  • Verified answer
    guk1964 Profile Picture
    10,888 on at

    Check the Ax tech specs I think you will find you need Enterprise SQL for this not Standard SQL.

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Some of those answers can be found in the System requirements guide, and the pre-requisites check is available with both the SQL Server and the AX installer kits.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans