CRM 2016 and can't run reports

(0) Share

Report

Posted on by USA80

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

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"

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
USA80 26 on at

Like (0)

Report

They do have the sys admin rights

Was this reply helpful? Yes No
Suggested answer

Abarao Bhople 445 on at

Like (0)

Report

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

Was this reply helpful? Yes No
jdalske 547 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

jdalske 547 on at

Like (0)

Report

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.

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.

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

Was this reply helpful? Yes No