Tags

, , ,

Hello Everyone,

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 :

  • CRMReaderRole
  • public
  • db_ownwer

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. 

Thanks !!!

:D

 

 

About these ads