I ran a Microsoft Update on my SQL server that has apparently broken the link
between CRM4 and SQL Reporting Services. After the update I started receiving
this error whenever I tried to run a report:
Microsoft CRM Unhandled Error Details: Server Error in '/' Application.
One or more data sources is missing credentials
I searched and found MS KB946289 that mentions this error when SQL 2005
critical update 934458 is installed. The fix they describe is either
repairing or reinstalling the CRM SSRS connector. I tried Repairing and
reinstalling the connector but the error did not go away. I then uninstalled
update 934458 and repaired/reinstalled the SSRS connector, still with no
success.
I am now at a loss as to how to proceed. I remember from the CRM 1.X days
there ways a way to re-publish all the reports, but that was when we were
dealing with Crystal reports. Can something similar be done with SSRS?
My test setup is fairly simple, with a 64-bit SQL 2005 server and a 32-bit
CRM server and no host headers.
Any help is much appreciated.
Thanks,
Mike