Yesterday, After a fresh new CRM server Installation When I ran the reports, the following Error showed up.
Reporting Error: The report cannot be displayed. (rsProcessingAborted)
Without wasting anytime I instantly opened the report server and tried to access those reports from there but failed with the same error, but a bit descriptive this time.
An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection) System.Data.Sql.Clinet.SqlException: Cannot open database "MSCRM_CONFIG" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\SYSTEM'. Cannot open database "MSCRM_CONFIG" requested by the login. The login failed. Login failed for user 'NT AUTHORITY/SYSTEM'.
I even checked for the logs in the Even Viewer and found the same:
Login failed for the user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'MSCRM_CONFIG'.[CLIENT: <local machine>]
I further went to see the reporting services details:
- Click Windows -> Run, Type “services.msc”
- Select “SQL Server Reporting Services(MSSQLSevrer)”
It was logged in as “Local System”.
Resolution: From the above error it was clear that the LocalSystem account login was not having the permission to connect to the CRM Database.
1> I then opened my SQL.
2> Went to Security -> Logins
3> Right Click NT Authority\SYSTEM (in my case)
4> Selected user MApping
5> Checked the MSSCRM_CONFIG and Org_MSCRM with roles of :
After assigning the above membership role for the following Login, the was no such error.
The same has been discussed in the following KB-Article which worked for me.
I thought its good to share ; while going through the other Articles for the same Issue, I found these two KB-Article1 and KB-Article2 which discuss about the other resolutions for the same, in case the above doesn’t work for your case/environment.
Hope that was helpful.