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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Problem with reporting...
Microsoft Dynamics AX (Archived)

Problem with reporting services and analysis services when using SQL server 2008 R2 "express" edition with AX 2012

(0) ShareShare
ReportReport
Posted on by Community Member

Hi ,

 

I have installed SQL server 2008 R2  "express" edition and Microsoft dynamics AX 2012 .

Though i am able to use AX , I am not able to deploy AX reports in to reporting server See the screen shot below when I am trying to test my report server configuration through powershell. it shows report manager and report server are not running

4380.ssrserr.png (669×479)

*This post is locked for comments

I have the same question (0)
  • MukeshHirwani Profile Picture
    MukeshHirwani 1,180 on at

    Did u installed & configured Reporting Services in SQL?

  • Suggested answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    Just as a sanity check, add a couple more parameters: Verbose, ServiceAOSName and ServiceAOSWSDLPort.

    Example Test-AXReportServerConfiguration -ServiceAOSName MyAOSServer -ServiceWSDLPort 8101 -Verbose

    If you are unsure what WSDL Port you are running, have a look at the Dynamics AX 2012 Service Configuration under Administrative Tools.

    Make sure you are polling the correct settings from the correct AOS.

    If indeed the correct instance is pulled, and reported as not started, then there is something fishy.

    EDIT: I just noticed the same as Mukesh. The componets are not installed. I will leave my answer in here still, for future reference (hopefully). ;-)

  • Community Member Profile Picture
    Community Member on at

    Hi Tom,

    Tried using the cmdlet you have suggested and this is what i got

  • Suggested answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    If the services are running and deployed on the AOS (keywords like AOT compiled, CIL compiled, initialization checklist run ok, etc), then my best guess is a firewall blocking traffic on the AOS server.

  • Community Member Profile Picture
    Community Member on at

    Hi Tom,

    Firewall is off,so i don't think it will cause a problem

    I am using an "express' edition of SQL server 2008 r2 will that be a problem?

  • MukeshHirwani Profile Picture
    MukeshHirwani 1,180 on at

    Narayan,

    Are u able to validate settings in System administration > Setup > Business Intelligence > Report Services > Report Servers?? If not, configure SSRS configuration first using Reporting services configuration manager.

  • Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    One know limitation with the Express flavor of SQL Server is that everything needs to reside inside SQL Server Express. This includes the Dynamics AX database and the SSRS database and service. I haven't used SQL Server Express for anything AX related, to be honest.

  • Community Member Profile Picture
    Community Member on at

    Mukesh,

    "Validation" does not through any error.

    Tom

    All the databases reside inside sql server express

    Has any one tried using SQL server express edition with AX 2012?

  • Community Member Profile Picture
    Community Member on at

    Hi ,

    I am using sql server 2008 "express edition".

    When i try to re install reporting server extensions

    I get the error log saying,

    "An error occurred while adding users domainname\user ,NT AUTHORITY\NETWORK SERVICE to the SQL Server Reporting Services DynamicsAXBrowser role in the folder DynamicsAX. The error is: The feature: "Customizing security roles" is not supported in this edition of Reporting Services..

    2013-03-05 19:53:38Z An error occurred during setup of Reporting Services extensions.

    2013-03-05 19:53:38Z Reason: The feature: "Customizing security roles" is not supported in this edition of Reporting Services."

    Can any one help on this?

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at

    Hi

    You have to create the follow record on Database ReportServer, Table Roles.

    64331790-405D-45B8-8EB1-A923B347C30E DynamicsAXBrowser Microsoft Dynamics AX browser role to view folders, reports and subscribe to reports. 0010101001000100 0

    Regards

    Denis

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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