Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

AX 2012 reports fail to deploy on a server hosting multiple SQL Server Reporting Server instances

by
on 14 Jun 2012
  • 0 comments

How do I publish AX 2012 SSRS Reports to default directory with this error?

by
on 11 Oct 2011
  • Not Answered

Installing second reporting service for AX2012

by
on 18 Nov 2011
  • Not Answered
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Test-AXReportServerConfiguration returns IsReportServerRunning : False

This question has suggested answer(s)
Tim Bolton
Posted by
on 1 Dec 2011 6:21 PM

I'm trying to deploy reports on a server running multiple report server instance using the documentation provided http://technet.microsoft.com/en-us/library/hh389760.aspx.

I found I've had to use -ServicesFilePath to nomininate the specific aos server I was refer to when running any of the report server management cmdlets. And these commands that talk only to the aos seem to work.

For example the following command works

PS C:\Windows\system32> $reports = Get-AXReport -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -ReportName account*

I can validate settings in the ax2012 client, create report folder etc. but for some reason Test-AXReportServerConfiguration and Publish-AXReport fail when  verifying the report server.

If anyone has any ideas, I'd love to hear them.

The publish command returns the following error

 Publish-AXReport -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -ReportName account* -Verbose

Deploying reports and related artifacts.

VERBOSE: Deploying the reports and artifacts to:

AOSName                   : 04@TSAP02

ConfigurationId           : XXX

Description               : 

Default                   : True

ReportServerFolder        : DynamicsAX

ReportServerName          : tssql02

ReportServerInstanceName  : XXX

ReportServerManagerUrl    : http://tssql02:9002/Reports_XXX

ReportServerWebServiceUrl : http://tssql02:9002/ReportServer_XXX

VERBOSE: Getting status for 04 AOS instance on server TSAP02.

VERBOSE: Verifying administrative access to server: tssql02.

VERBOSE: Verifying the report server URL http://tssql02:9002/ReportServer_XXX.

Publish-AXReport : Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.

At line:1 char:17

+ Publish-AXReport <<<<  -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -ReportName account* -Verbose

    + CategoryInfo          : InvalidOperation: (:) [Publish-AXReport], InvalidOperationException

    + FullyQualifiedErrorId : Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service 

    URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

Publish-AXReport : The deployment was cancelled because of an error. On the report server, verify that:

- The SQL Server Reporting Services service is running.

- SQL Server Reporting Services is configured according to the instructions in the Microsoft Dynamics AX Installation Guide

 (http://go.microsoft.com/fwlink/?LinkID=163796).

- The Remote Administration feature is allowed to communicate through Windows Firewall.

At line:1 char:17

+ Publish-AXReport <<<<  -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -ReportName account* -Verbose

    + CategoryInfo          : ResourceUnavailable: (Microsoft.Dynam...ReportsDeployer:ReportsDeployer) [Publish-AXReport], 

    ServerException

    + FullyQualifiedErrorId : The deployment was cancelled because of an error. On the report server, verify that:

- The SQL Server Reporting Services service is running.

    - SQL Server Reporting Services is configured according to the instructions in the Microsoft Dynamics AX Installation  

   Guide (http://go.microsoft.com/fwlink/?LinkID=163796).

    - The Remote Administration feature is allowed to communicate through Windows Firewall.,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

 

Deployment completed.

Publish-AXReport : Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.

At line:1 char:17

+ Publish-AXReport <<<<  -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportSe

rver\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -ReportName account* -Verbose

    + CategoryInfo          : NotSpecified: (:) [Publish-AXReport], InvalidOperationException

    + FullyQualifiedErrorId : System.InvalidOperationException,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

The test report server configuration returns the following error

PS C:\Windows\system32> Test-AXReportServerConfiguration -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -Verbose

Testing the report server configurations.

VERBOSE: Testing report server configuration: XXX.

VERBOSE: Getting status for 04 AOS instance on server TSAP02.

VERBOSE: Verifying administrative access to server: TSAP02.

VERBOSE: Verifying administrative access to server: tssql02.

VERBOSE: Verifying the report manager URL http://tssql02:9002/Reports_XXX.

VERBOSE: Verifying the report server URL http://tssql02:9002/ReportServer_XXX.

Test-AXReportServerConfiguration : Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Ser

vice URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.

At line:1 char:33

+ Test-AXReportServerConfiguration <<<<  -ServicesFilePath "C:\Program Files\Microsoft SQL Server\MSRS10_50.XXX\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc" -Verbose

    + CategoryInfo          : InvalidOperation: (:) [Test-AXReportServerConfiguration], InvalidOperationException

    + FullyQualifiedErrorId : Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service 

    URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.,Microsoft.Dynamics.AX.Framework.Management.Reports.TestReportServerConfigurationCommand

VERBOSE: Trying to read the User Account Control (UAC) value on server: TSAP02.

VERBOSE: Trying to read the User Account Control (UAC) value on server: tssql02.

IsAOSRunning                  : True

IsCurrentUserAdminOnAOSServer : True

IsCurrentUserAdminOnSRSServer : True

IsReportManagerRunning        : True

IsReportServerRunning         : False

IsUACDisabledOnAOSServer      : True

IsUACDisabledOnSRSServer      : True

Testing the report server configurations completed.

 

deployment SSRS ax2012
All Replies
  • Denis Macchinetti
    Posted by
    on 9 Dec 2011 7:37 AM

    Hi Tim

    I have the same problem.

    you have fix ?

    thanks

    Denis
  • Denis Macchinetti
    Posted by
    on 14 Dec 2011 4:08 AM
    Suggested Answer

    Hi

    I have uninstall the second instance of Reporting Services and install again.

    After that i have follow the steps listed on TechNet page Install multiple instances of Reporting Services on the same computer (for use with Microsoft Dynamics AX) [AX 2012] (technet.microsoft.com/.../hh389760.aspx)  and now all work fine.

    Denis
  • Tim Bolton
    Posted by
    on 14 Dec 2011 5:50 PM

    Hi Denis,

    I did resolve the issue, but I'm not entirely sure how, I configured the default report server on port 80, and set it up, and then somehow, they all started working, so unfortunately, I'm not certain what fixed this issue.

    Tim
  • Bart Heuvel
    Posted by
    on 14 Mar 2012 6:20 AM

    Hey Tim,

    I'm looking at the same problem here. I uninstalled and reinstalled several times now, and reconfigured ports several times now. I keep getting this problem though. Did either of you ever get a grasp of what was wrong that could help me in the right direction?

    Thanks!

    Bart
  • Chris T
    Posted by
    on 14 May 2012 9:51 AM

    Hi Guys,

    I have exactly this issue, can't work out what I've done wrong!

    Anyone any further forward?
  • Michael H
    Posted by
    on 24 May 2012 5:52 AM
    Suggested Answer

    Hi everybody,

    Open SQL Server Management Studio and connect to the ReportServer Instance. Open the properties dialog of this instance.

    You will find a URL field there. Make sure this URL is the exact same one used by Dynamics AX. Since this is a read-only field, you need to use ReportServer Configuration Manager to change the URL. This URL could be different from the URL used in Dynamics AX if you use multiple bindings in ReportServer (SSL an non-SSL for example).

    In my case there was a http://-URL in that field but Dynamics used a https://-URL (with SSL). In the ReportServer Configuration Manager i simply removed all non-SSL bindings.

     

    After a restart of the ReportServer instance the message "IsReportServerRunning : False" was gone and i could publish and use reports!

    Michael
  • Denis Macchinetti
    Posted by
    on 24 May 2012 6:59 AM

    ALL

    In my all installation of AX 2012 during SSRS Reports deployment often happen that AX give me the message : "IsReportServerRunning         : False"

    I have create also a Microsoft Support request.

    Also Microsoft tell me to reinstall the SQL Reporting Service Instance.

    Regards

    Denis Macchinetti
  • Peter Griffin
    Posted by
    on 4 Jul 2012 11:07 AM

    Hello,

    there is a possible solution from the AX support in this blog:

    http://community.dynamics.com/product/ax/axtechnical/b/axsupport/archive/2012/06/14/ax-2012-reports-fail-to-deploy-on-a-server-hosting-multiple-sql-server-reporting-server-instances.aspx

     

    Regards

    Peter
  • Denis Macchinetti
    Posted by
    on 5 Jul 2012 4:51 AM

    Many thanks !

    Denis