• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1486
  • Last Modified:

CRM 4.0 Reporting Error

We have MS CRM 4.0 installed on the same server as SQL Reporting and SRS Data Connector.  When I try to run reports from server or workstation, get "Report could not be displayed" error.  In Event Viewer, get 2 messages MSCRMReporting SoapException Login Failed, and an ASP .Net warning.  Have tried all fixes I have found on the web.  Nothing works!  Help!!
0
JSRich
Asked:
JSRich
  • 2
1 Solution
 
tbsgadiCommented:
Have a look at the following:

http://support.microsoft.com/kb/946585

Gary
0
 
WilyGuyCommented:
My initial guess is that you don't have the SRS Data Connector installed?  It is on the CRM Media.  it will kick up a warning if you are running both the SRS App Pool and the CRM App Pool with the same account.  I believe you used to not be able to install it, but if you do the server updates, you can move past that and still install it.

Be sure to IISRESET after installation.
0
 
JSRichAuthor Commented:
Thank you for your replies!  I have already tried the MS KnowledgeBase article.  The SRS Data Connector is installed, but when I installed it, it said that there was already an instance of Microsoft CRM connected.

When I try to run reports:  On the Workstation I get "Reporting Error: The report cannot be displayed";  In the Server's Event Logs I get 3 entries:  "Error!  Web service request GetDataSources to Report Server http://myserver:8085/reportserver failed with SoapException Error: Logon failed (rsLogonFailed)", "Error!  Web service request GetDataSources to Report Server http://myserver:8085/reportserver failed with SoapException Error: The path of the item '/company_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 a slash (rsInvalidItemPath)", and "Warning!  ASP.NET 2.0.50727.0  Event Code: 3005  Event Message: An unhandled exception occurred.  Event Time: timestamp  Event ID: 54eb648a8781453c9dff40d13c413605  Event Sequence: 2052  Event Occurrance: 1  Event Detail Code: 0"

We are running the CRM on a specified port.  And I know that the second error message is incorrect because I can browse to it from http://myserver:8085/reportserver (although this does take a long time to come up).  I have tried setting the permissions on the NETWORK SERVICE, I have tried looking for duplicate entries for MSCRM Extensions, I have even tried editing the connection string in the report itself (it has the MSCRM database as Adventure_Works_Cycle_MSCRM), still no luck.
0
 
JSRichAuthor Commented:
Finally fixed it!  Was a combination of several things:

Modify the Microsoft Dynamics CRM 4.0 web.config file so that SQL Server Reporting Services ignores the Microsoft Dynamics CRM 4.0 error - http://support.microsoft.com/kb/948012

Do not specify an Execution account in Reporting Services (having a yellow exclaimation is correct)

Creating correct groups in Active Directory Users and Computers - went to http://myserver:8085/reports, clicked on Security, saw what domain groups had permissions (they were listed, but did not actually exist).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now