Today I got the following message… “Could you just fix the reports on this AX 2012 environment… It is broken”
Then I tried to validate the report configuration I got the following error:
The SQL Server Reporting Services server name [servername] does not exist or the Web service URL is not valid.
OK… First test:
Can I browse to the report URLs in System Administration – Business Intelligence – Reporting Services – Report Servers.
No I could not, from the AX Server. it worked from the SQL Server so I checked the firewall on the SSRS Server and added port 80.
I still get the same issue when validating. So I opened the Microsoft Dynamics AX 2012 Management Shell as an administrator and ran Test-AXReportServerConfiguration
What… I opened the port and I can browse to the URLs. Apparently the as scripts tests for Remote Admin Ports so when I open those ports using this netsh command
netsh.exe firewall set service type=REMOTEADMIN mode=ENABLE scope=ALL
Presto!! The validation was successful!!