Hi guys,

Currently I'm facing SSRS problem. When I run the report, it will show like this.

When I see inside the reporting service log, it show this error.

processing!ReportServer_0-1!d18!03/06/2014-15:00:08:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'Adventure_Works_Cycle_MSCRM'. ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: Immediate caller NT AUTHORITY\NETWORK SERVICE has insufficient privilege to run report as user S-1-5-21-1311266088-118511792-1381041710-500.
   at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.Assert(Boolean condition, String message)
   at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.ValidateCaller(SecurityIdentifier user)
   at Microsoft.Crm.Reporting.DataExtension.Common.DataExtensionConnectionBase.<>c__DisplayClass1.<Open>b__0()
   at Microsoft.Crm.Reporting.DataExtension.Common.ExceptionManager.HandleUnsafeException(Action body)
   at Microsoft.Crm.Reporting.DataExtensionShim.Common.ICrmDbConnectionExtension.Open(String userSid)
   at Microsoft.Crm.Reporting.DataExtensionShim.Common.SrsExtConnectionBase.Open()
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
   --- End of inner exception stack trace ---;

Can you guys help me to solve this problem? Already facing this problem for 2 weeks :-(

The error itself states that there is a rights related issue

Cannot create a connection to data source 
'Adventure_Works_Cycle_MSCRM'. ---> 
Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: 
Immediate caller NT AUTHORITY\NETWORK SERVICE has 
insufficient privilege to run report as user 

Hi mr_nougat,

According to the error message, we can notice that you are using NT AUTHORITY\NETWORK SERVICE build-in account as the Report Server Services Account, while this account has insufficient privilege connect to the CRM Database ('Adventure_Works_Cycle_MSCRM').
In order to fix this issue, we can refer to the following steps:

1. Start SQL Server Management Studio.
   
2. Expand Security, then expand Logins.
   
3. Select and right click the account under which the SQL Server Reporting Services is running (in your scenario, it is NT AUTHORITY\NETWORK SERVICE).
   
4. Select User Mapping and select Adventure_Works_Cycle_MSCRM database and specify following role memberships:
    CRMReaderRole
    db_owner
    public
   

The screenshot is for your reference:
 
Hope this helps.

Thanks,
Katherine Xiong

Hi Katherine Ziong,

I cant find 'Adventure_Works_Cycle_MSCRM' database. Did I install the CRM reporting extension wrongly?

Hi mr_nougat,

As per my understanding, I think may be you have not installed Microsoft Dynamics CRM Reporting Extensions successfully. For the correct steps, we can refer to the following two links:
http://technet.microsoft.com/en-us/library/hh699807.aspx
http://blogs.msdn.com/b/niran_belliappa/archive/2013/11/05/step-by-step-installing-dynamics-crm-2013-on-windows-server-2012.aspx

Hope this helps.

Thanks,
Katherine Xiong

Hi Katherine,

will try to re-install it and give you the result :-)

Hi, I am using ms crm 2013 with sql on a diffrent server. I am facing the same issue, tried all priviliges and reporting extension is installed.

Still I get the error

• Cannot create a connection to data source
  'DataSource1'. (rsErrorOpeningConnection)
  
  • Immediate caller NT AUTHORITY\NETWORK SERVICE has
    insufficient privilege to run report as user
    S-1-5-21-320563158-1871118109-716098633-26609.

  Please help.

Hi,

I am facing same issue, using ms crm 2013 with sql on a diffrent server. tried all priviliges and reporting extension is installed.

Still I get the error

• Cannot create a connection to data source 
  'DataSource1'. (rsErrorOpeningConnection)
  
  • Immediate caller NT AUTHORITY\NETWORK SERVICE has 
    insufficient privilege to run report as user 
    S-1-5-21-320563158-1871118109-716098633-26609.

  Please help.