We last published a report about 3 months ago. Everything worked fine then. We attempted to publish a single report last week and received the following error:
Permissions / setup haven't changed so I'm not 100% convinced of the 'Access is denied' error. We have tried the 'Publish' command on both custom and out of the box reports with the same result.
In troubleshooting I went to one of our AOS servers and ran the test-axreportserverconfiguration command in the AX powershell. The following was the result:
The one thing that stuck our to me was the 'False' on the report server URL being accessible. I am able to access that URL via web browser on this machine.
UPDATE:
In looking at the 'System' event viewer logs, I found that it is logging the following error when attempting both of these actions:
The server-side authentication level policy does not allow the user MYDOMAIN\myuser SID (S-1-5-21-796845957-1409082233-839522115-18752) from address [IP Address of server performing above actions] to activate DCOM server. Please raise the activation authentication level at least to RPC_C_AUTHN_LEVEL_PKT_INTEGRITY in client application.
A search of this error leads me to the following:
I don't see this KB as having been installed, however, it appears that DCOM hardness is the main suspect at the moment.
Manually deploy reports through Microsoft SQL Report Deployment Wizard.
Yes, I have full access to the the URLs.
Have a look at reporting server config. Check if you are able to access SSRS report from the bowser server URL.
Yes, I have access to the SSRS report folder. (Full access)
Do you have access on SSRS report folder? please check.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156