When you run a simple report on CRM 4.0 server, if its throwing the below error and says that in event viewer:
Report Error: The report cannot be displayed.
and back in event properties, it shows the below message: I’m the Admin on CRM server, SSRS server and SQL Server server and I choose the ‘password never expires’ option.
Please let me know.
Event Type: Error
Event Source: MSCRMReporting
Event Category: None
Event ID: 19969
Date: 9/13/2011
Time: 8:59:02 AM
User: N/A
Computer: CRMServer
Description:
Web service request GetDataSources to Report Server http://CRMServer/ReportServer failed with SoapException. Error: Logon failed. (rsLogonFailed)
Answers Check Points:
Check Point 1:
Please republish the reports in CRM server by using a command-line program. by using the path
C:Program FilesMicrosoft Dynamics CRM and then to Tools. Within this folder run the following command:
C:Program FilesMicrosoft Dynamics CRMTools> PublishReports “organizationname”
where organization name is the internal name of the CRM organization (as found in Deployment Manager).
Check Point 2:
Check whether the server has installed with latest rollup or not, and make sure to install the Latest SRS Data Connector on the server.
Check Point 3:
if there are two data sources for the SSRS and MS CRM server. follow the below link
Check Point 4:
you can diagnose the connection errors by using the CRM Diag tool
Check Point 5:
check whether the Report Server has configured by using the Network Admin Account.
Check Point 6:
Please follow the below link to configure SRS Data connector