Up front, I am not a Dynamics person in any way. I work with SQL Server and SQL Server Reporting Services.
On the front end a collegue got the rsProcessingAborted error. She found a log entry in the SSRS log:
Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The user name or password is incorrect.
When I check the shared data source MSCRM_FetchDataSource that is of type Microsoft Dynamics CRM Fetch. The data source prompts the user for user name and password.
One thing that puzzled me was that the connection string was a single word (not a URL) that was an abbreviation for the company name. So I am not sure that that is the true reference to the CRM datasource. Could it be the actual reference? Where would I plug that connection string to test it (remember no Dynamics knowledge at all)? Or does this single word reference some configuration that is stored elsewhere?
The reports ran with that connection about a month ago and were run for the first time last week.
What should I suggest my collegue look into?
Thanks!
*This post is locked for comments
I have the same question (0)
