You’re offline. This is a read only version of the page.
1,858
After uninstalling ax reporting services extension from database server,
when I try to install it back, the setup doesn't asks for the AOS instance whereas when I installed it on a fresh server it asked me for the AOS instance.
How can make it prompt me the AOS server again on reinstall ? Any file to delete?
*This post is locked for comments
Now I'm able to use Dynamics AX 2012 Powershell from 112 (client,AOS). But Powershell is throwing the same error from 136.
I made some errors in one of the steps here (Not sure of the order) which fixed the deployment from 112:
1. SSRS configuration settings
2. AOS Server in Configuration. And then copying the right config file to SRS folder on DB Server.
I also noticed that:
Even when the AOS server was stopped, reports link was still working from 136 in Web browser, but might not run though? not sure will check later on if AOS is required after the reports are deployed.
Check your SSRS configuration settings in your AX System administration module. Is it pointing to the correct SSRS instance?
And when you publish the reports (docs.microsoft.com/.../publish-axreport) you can specify which configuration id (of that settings table) you want to use when publishing. If you have multiple SSRS instances for one AX you need to run the publish process separately for each instance.
Fantastic! Thanks Nikolaos, That cleared up things for me. Now I'm running into a different Issue.
Here's how my services are setup:
Server112: AX Client and AOS
Server107: DatabaseServer
Server136: ReportingServices+AX Reporting Services Extension
I copied the AX client configuration into SRS folder on Server107 as explained in the Step2 Link of your answer.
Now:
1. I am able to deploy reports from AOT on 112.
2. When I try to deploy report from 112 using Dynamics AX 2012 PowerShell:
It deploys to a different report server. (To a report server where this setup was cloned from, it's a test server)
3. When I try to deploy report from 136 using Dynamics AX 2012 PowerShell:
It throws this error below:
PS C:\Windows\system32> Publish-AXReport -ReportName VendBalanceList
Deploying reports and related artifacts.
WARNING: The default Report Server Configuration ID could not be found in the
SRSServers table.
Publish-AXReport : Make sure that Microsoft Dynamics AX Business Intelligence
Components are installed on the SQL Server Reporting machine and verify that
SQL Server Reporting Services is configured correctly matching the report
server configuration in the Microsoft Dynamics AX client.
At line:1 char:1
+ Publish-AXReport -ReportName VendBalanceList
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotInstalled: (:) [Publish-AXReport], InvalidOpe
rationException
+ FullyQualifiedErrorId : Make sure that Microsoft Dynamics AX Business In
telligence Components are installed on the SQL Server Reporting machine an
d verify that SQL Server Reporting Services is configured correctly matchi
ng the report server configuration in the Microsoft Dynamics AX client.,Mi
crosoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand
Deployment completed.
Thanks.
Hi MYGz ,
As the marked answer in this case:community.dynamics.com/.../187076 ,you need to install and configure Reporting services for SQL on machine where you want to install Reporting extentions of AX/AOS. SQL reporting services are prerequisites for AX reporting extension.
Best Regards
Tom Cai
Most likely after the uninstall, there are still some registry settings left behind. You could try to find them and change the AOS settings there. Or you can simply provide an .axc file (AX client configuration) for the Reporting Services to make it connect to any AOS that you want. docs.microsoft.com/.../create-a-new-microsoft-dynamics-ax-configuration
1. Yes, it must be installed on the same server where SSRS is running.
2. Yes, you can have SSRS service and SSRS database on different servers. (docs.microsoft.com/.../configure-a-report-server-database-connection-ssrs-configuration-manager)
Hi Tom,
Yes. I have temporarily fix the issue by installing the Reporting server and AX Reporting services extension on a different machine.
Can you also answer these points:
1. AX reporting services extension is installed on the same server where SQL reporting services are running right?
2. Does the SQL reporting services has to be installed on the same server where ReportServer database is running? Is it possible to install reporting services and Ax extension on 1 server and the ReportServer database is on another Server (or on a database cluster)
Thanks.
Hi MYGz,
Do you want to change the aos instance?
Best Regards
Tom Cai
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (