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
Deepu Mathew
March 10, 2010 at 09:57
Thanks a lot!!! I was running into the same issue and this helped.
Stacy
July 4, 2011 at 02:57
Thanks so much! Was running into this issue and change the connection details as per your article solved it.
Crystal
October 9, 2011 at 09:56
Done well, you have gained a whole new fan, resources much like the one you mentioned here are very beneficial in my opinion. I most certainly will post a hyperlink to that page in my blog. Most likely my visitors will discover this very helpful, please visit my website sometime as well as leaving us a comment to allow me read your comments. Regards,