Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2016 and can't...
Microsoft Dynamics CRM (Archived)

CRM 2016 and can't run reports

(0) ShareShare
ReportReport
Posted on by USA80 2,645

When I try to run a report in CRM 2016 I get an error that says,"The report cannot be displayed. (rsProcessingAborted)."

When I check the reporting logs I see the following:

ERROR: An exception has occurred in data source 'CRM'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'CRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.
Login failed for user . ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed.

Any help with this is greatly appreciated.  Thank you.

*This post is locked for comments

  • Suggested answer
    jdalske Profile Picture
    jdalske 536 on at
    RE: CRM 2016 and can't run reports

    Did you happen to change the Name of the report on the report server?  I did and wasn't aware that the GUID needs to stay and you can use the description to "name" the report.

    pastedimage1579099358382v1.png

    If you did, you can find the GUID in the address bar betwe %7b and %7d when you click to run the report.  See below.

    pastedimage1579099625658v2.png

    Copy and paste it in { } and apply the changes.  This should resolve the issue.

  • jdalske Profile Picture
    jdalske 536 on at
    RE: CRM 2016 and can't run reports

    I have network service listed as the user.  Would that be correct?  How do I give that account access when I don't even know what it is?

    Thank you. Your information has been helpful so far.

  • Suggested answer
    Abarao Bhople Profile Picture
    Abarao Bhople 445 on at
    RE: CRM 2016 and can't run reports

    Hi ,

    Could you please let me know if you are able to open Out the box reports try to open below report.

    Account Distribution

    if you are able to run OOB reports then need to look at your custom reports.

    if possible , send me the log of reporting folder where the reporting extension is installed.

    <SQL INSTALLDIR>\MSRS11.MSSQLSERVER\Reporting Services\LogFiles

     

    Thank you.

    Abarao Bhople

     

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: CRM 2016 and can't run reports

    They do have the sys admin rights

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: CRM 2016 and can't run reports

    Make sure the user you logged in into the server and the user you added in the reporting service has System Administrator permission in the SQL server Database. So check the user has added in the database .

    www.youtube.com/watch

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: CRM 2016 and can't run reports

    if I do a repair on SQL Server 2016, I get an error that says, "Index was out of range. Must ben non-negative and less than the side of the collection. Parameter name: index"

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: CRM 2016 and can't run reports

    I also had to update SSRS from 2012 to 2016 and now when I try to start the SQL Server Reporting Service (MSSQLSERVER), I get an error that says, access is denied.  What do I need to check for this?

  • Suggested answer
    gdas Profile Picture
    gdas 50,085 on at
    RE: CRM 2016 and can't run reports

    Hi,

    As error says that the user under which reporting server is running does not have CRM database access . So you need to check following -

    - Open Reporting Service Configuration manager and check which service account you have used.

       Check here in the second screenshot in below reference -

        docs.microsoft.com/.../configure-ssrs-on-premises

    -- Go to Database server and Open SQL Server Management Studio .Add the same Reporting Server  service account user under security of SQL server Database and give full access.

    Make sure you can browse the report  Report Server URL .

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans