We had a working Dynamics CRM installation, with one Organization, xxxxx.
Everything worked, including reporting.
CRM is on one server, and SQL Server is on another server.
Next, I created a new Organization ‘yyyyy’, using the deployment manager.
I disabled the old organization, and then I deleted it.
Everything is working now, except reporting.
We are getting the following exception:
Event Type: Error
Event Source: MSCRMReporting
Event Category: None
Event ID: 19969
Date: 17/09/2010
Time: 7:28:33 AM
User: N/A
Computer: zzzzzzzzzzzzzzz
Description:
Web service request GetDataSources to Report Server
http://wwwwwwwww:87/ReportServer failed with SoapException. Error: The path of the item '/yyyyy’_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If
the report server is in native mode, the path must start with slash. (rsInvalidItemPath)
We are using SQL Connector for SSRS, with update rollup 7 and then 12 applied.
Our servers are Windows Server 2003 R2.
Note we also see this event:
Event Type:
Error
Event Source: MSCRMReporting
Event Category: None
Event ID: 19969
Date: 17/09/2010
Time: 7:28:27 AM
User: N/A
Computer: zzzzzzzzzzzzzzz
Description:
Web service request GetDataSources to Report Server http://wwwwwwwww:87/ReportServer failed with SoapException.
Error: Logon failed. (rsLogonFailed)
Do you have any suggestions for us?