When you have installed the SRS data connector for MS CRM 4.0, you may receive the following error message when trying to run a report from within CRM:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘CRM’. (rsErrorOpeningConnection)
Value cannot be null. Parameter name: g
My first thought was the datasource for the report was not set correctly.
I found out that CRM creates another datasource beside the standard DataSource located in the folder of your organisation.
So, this means you will have 2 datasource for your CRM organisation.
The default, located at <orgname>_MSCRM\MSCRM_DataSource
And the SRS data connector DataSource under <orgname>_MSCRM\4.0\MSCRM_DataSource
It seemed the SRS data connector DataSource was not configured correctly.
Make sure following configuration is set.
SRS data connector DataSource under <orgname>_MSCRM\4.0\MSCRM_DataSource:
Data Source Type: Microsoft CRM Data Extension
Connection String: MSCRM Data Connector Connection String
Connect Using: Credentials supplied by the user running the report (This setting was wrong in my case)
Default DataSource:
Data Source Type: Microsoft SQL Server
Connection String: Data Source=<ServerName>;Initial Catalog=<orgname>_MSCRM;Integrated Security=SSPI
Connect Using: Windows integrated security
