Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Error running reports
Microsoft Dynamics CRM (Archived)

Error running reports

(0) ShareShare
ReportReport
Posted on by Community Member

When trying to run reports we are getting a Reporting Error

Reporting Error  The Report can not be displayed (rsProscessingAborted) with the options Try Again or Close.  We hit Try again and get an Invalid Argument error.  We can hit Try again 4 times and get yet another error -

404 - File or directory not found.

The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

I had my Network admin take a look and she is seeing this:

processing!ReportServer_0-81!519c!02/04/2019-08:16:09:: e ERROR: Data source 'CRM': An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:

System.Runtime.InteropServices.COMException: The user name or password is incorrect.

---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The user name or password is incorrect.

 

This is happening with any report we try to run, including User Summary.  

Any suggestions would be great.

Thank you

*This post is locked for comments

  • Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Error running reports

    Hi,

    If you don't know the reporting server,

    1. Log in to your CRM Server and launch the Deployment Manager

    2. In the left menu click Organizations

    3. Right click your organizetion > Properties

    4. In the Properties dialog, validate the report server URL (most probably it is the SSRS server name)

    5. login to the SSRS server and follow the steps in the link previously provided

    Hope this help!

    Charles.

  • empath-e CRM Profile Picture
    empath-e CRM 1,136 on at
    RE: Error running reports

    Check your SQL Server

  • Community Member Profile Picture
    Community Member on at
    RE: Error running reports

    We are running CRM 2011 and I do not see the Reporting Services Configuration Manager application on our server.

  • empath-e CRM Profile Picture
    empath-e CRM 1,136 on at
    RE: Error running reports

    As per Kokulan's response. If you have a user set ensure the password is correct. It may have been changed and not updated here?

  • Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Error running reports

    Hello,

    Please refer to Microsoft link for how to configure the reporting services for on-premise environments. docs.microsoft.com/.../configure-ssrs-on-premises

    Hope this helps!

    Charles Abi Khirs.

  • Community Member Profile Picture
    Community Member on at
    RE: Error running reports

    Good Morning.

    This has worked in the past.  Reports are run monthly about this time.

    1.  The report server is up and running

    2.  How do we check reporting services? to make sure they are configured properly, however reports have worked previously.

    3.  It is happening to all users, even System Admin.

  • Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: Error running reports

    Hello,

    Can you check the below:

    1. Report server is up and running

    2. Reporting services are properly configured for your CRM

    3. Is it happening to all users even System Admin?

    Charles Abi Khirs

  • Suggested answer
    Kokulan Profile Picture
    Kokulan 18,052 on at
    RE: Error running reports

    Hi

    The error message clearly states that the Data Source  connection fails because of invalid credentials

    Could you please login to the Report Manager and check the Data Source Properties and make sure its got valid credentials and its type set.

    ScreenClip-_5B00_77_5D00_.png

    Please refer to following links if you would like to have read to know more about these settings

    https://docs.microsoft.com/en-us/sql/reporting-services/report-data/specify-credential-and-connection-information-for-report-data-sources?view=sql-server-2017

    https://docs.microsoft.com/en-us/sql/reporting-services/report-data/store-credentials-in-a-reporting-services-data-source?view=sql-server-2017

    Hope this helps

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans