Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

SSRS report error

(0) ShareShare
ReportReport
Posted on by 514

When running reports in the test application i am getting the below error message:

The logon attempt failed.20125.jpg

Kindly help me in this regard.

  • sagar_patil Profile Picture
    sagar_patil 514 on at
    RE: SSRS report error

    Not able to generate any report. Getting error as mentioned.

  • sagar_patil Profile Picture
    sagar_patil 514 on at
    RE: SSRS report error

    1.This generates an error message on the report server

    4503.jpg

    2. It also generates the below error message on the AOS server 

    6038.jpg

    We have checked the following.

    • BCP Service account is the same as the account running the report services

    8030.png

    The BCP user is able to run reports directly on the report server.

     

    We are able to validate the settings on the report server from the application.

    1307.png

  • XB Profile Picture
    XB 1,867 on at
    RE: SSRS report error

    is the pass user expired?

    is only this report?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: SSRS report error

    You didn't tell if it was working before or not. If it was, it's good to evaluate what has been changed since it last worked. This would help you find the issue quicker.

    The first things to check are:

    1) Is your test system connected to your test SSRS instance (System administration - Setup - Business Intelligence - Report servers)? Perhaps you copied database from Prod and your test is trying to talk to your prod SSRS instance

    2) Is SSRS service running as Business connector proxy account? It should

    3) Is your AX user added as user on the SSRS site, with "DynamicsAXBrowser" role?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,472 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,560 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans